Query to find resrouces with unsubmitted timesheet

— attempt to id non-reporters
–find full list of resources
select wr.res_name
from MSP_WEB_RESOURCES WR,MSP_TEXT_FIELDS TXTFLD, MSP_CONVERSIONS CONV
where WR.RES_EUID = TXTFLD.TEXT_REF_UID
and  TXTFLD.TEXT_FIELD_ID = CONV.CONV_VALUE
and TXTFLD.text_category = 1
and proj_id = 1
and conv_string = ‘Resource Group’
and wr.RES_NAME not in
        ( — list of resources who have pending task updates.
                select distinct R.RES_NAME
                from MSP_WEB_ASSIGNMENTS A, MSP_WEB_PROJECTS P, MSP_WEB_RESOURCES R
                where A.WASSN_ACTUALS_PENDING =1 — flag to indicate task is pending manager approval
                and A.wproj_id = P.WPROJ_ID
                AND R.WRES_ID = A.WRES_ID
        )
order by res_name

Leave a Reply

Enter the CAPTCHA * Time limit is exhausted. Please reload CAPTCHA.