Can I see other users' assignments ?

ricpike

Can I run a livereport to see the assignments that other users have ?

Find more posts tagged with

Comments

Greg_Griffiths_(greggriffiths_-_(deleted))

Yes you can, if you know where to look in the DB ;-) Are you looking at WF or normal tasks ? which DB are you using ?

Fred_Vreeswijk

select subwork_title "Workflow", subworktask_title "Task", subworktask_performerID_name "Assigned To", max(workaudit_date) "Last Activity" from todo, waudittrail where todo.work_workid = waudittrail.workaudit_workid and todo.subwork_subworkid = waudittrail.workaudit_subworkid and todo.subworktask_taskid = waudittrail.workaudit_taskid group by subwork_title, subworktask_title, subworktask_performerid_name order by max(workaudit_date)