Query to find resrouces with unsubmitted timesheet

Share on facebook
Share on twitter
Share on linkedin

— 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

Sign up for Softvative Newsletter

Receive the latest technology and leadership news and resources from us

Subscribe To Softvative Newsletter

Get notified about new articles

Share on facebook
Share on twitter
Share on linkedin
Share on pinterest