Has anyone created a Delinquent Time Sheet portlet that they can share with use. We've configured time sheets for auto-approval, but managers would like visibility on who hasn't submitted a time sheet for the previous week. We would like to distinquish between 'Unsubmitted' and 'Missing', and filter on Resource Group. Thanks!
Mahendran - Thanks for the query. I got the same 'missing expression' error when I tried to run it, but I tracked it down to an incomplete 'and usr.location_code in' clause in the first 'select' statement. I suspect you had removed your proprietary location codes. I commented out all references to 'location_code' and the query ran fine. It looks like a great start for what we need. Thanks for your help!
mcmunnd1 - Note, you'll also want to change or remove the references to 'prodpitg' in the query. I suspect that's the name of Mahendran's production ITG database.
Mahendran - Sorry, I misunderstood your question the first time. You configure auto-approval in the Time Sheet Policy. It's the bottom check box on the first configuration tab. Once set, time sheets created under that policy will be automatically flagged as approved as soon as they're submitted.
Notes: You'll need to configure the Time Sheet Policy through the Workbench. Also, even though the resource can auto-approve their time sheet, they must still be assigned a default Time Approver (go figure). Hope that helps, and thanks again for the sample query!