Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Content Management (Extended ECM)
API, SDK, REST and Web Services
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)