J
Jesse
originally posted to the dev thread...
I want to determine if an update submitted by a resource for approval by the
project manager is for time 30 days prior to submission date or older.
Ultimately I might look to create a trigger to be informed anytime such an
update is submitted.
The query below will tell me if a resource has an update to their timesheet
that they haven't submitted or if a resource has submitted an update to the
PM for approval.
I don't know how to tell what date(s) the task update is for. Can someone
help me out?
select wres_id, wproj_id, wres_id_mgr,
wassn_actuals_pending,
wassn_update_status, wassn_send_update_date,
task_id, task_uid, task_name
from dbo.MSP_WEB_ASSIGNMENTS
where wproj_id = 909 and wres_id = 351 and
(wassn_actuals_pending = 1 or wassn_update_status = 1)
I want to determine if an update submitted by a resource for approval by the
project manager is for time 30 days prior to submission date or older.
Ultimately I might look to create a trigger to be informed anytime such an
update is submitted.
The query below will tell me if a resource has an update to their timesheet
that they haven't submitted or if a resource has submitted an update to the
PM for approval.
I don't know how to tell what date(s) the task update is for. Can someone
help me out?
select wres_id, wproj_id, wres_id_mgr,
wassn_actuals_pending,
wassn_update_status, wassn_send_update_date,
task_id, task_uid, task_name
from dbo.MSP_WEB_ASSIGNMENTS
where wproj_id = 909 and wres_id = 351 and
(wassn_actuals_pending = 1 or wassn_update_status = 1)