I created a custom query to find user who have not submited their timesheets.
I want to create is as report on PPM system. And I want to run it every monday.
I created a new report on admin menu > configuration > Report types
on this report they where shall I wtire the query?
I only find custom command place on the screen below.
Is here the right place?
Shall I definethe query here?
Or any other method?
select ku.full_name, ku.email_address from PPMTFKB_USR.knta_users ku where ku.end_date is null and ku.user_id not in ( select ts.resource_id from ppmtfkb_usr.tm_time_sheets ts where ts.period_id in(select kp.period_id-1 from ppmtfkb_usr.KTMG_PERIODS kp where kp.start_date < (select sysdate from dual) and kp.end_date > (select sysdate from dual)) and ts.status_code in (2,4,6,7) --pending approval, approved, frozen, closed ) and ku.user_id in (select up.user_id from ppmtfkb_usr.knta_user_products up where up.product_id=5)