D2 - Widgets Query

#User Inbox

#================================================

select stamp,stamp as r_object_id,task_state,item_type,priority,item_name,item_id,item_id as associate_id,task_name,task_subject,event,name,sent_by,date_sent,due_date,instruction_page,content_type,read_flag,router_id,supervisor_name from dmi_queue_item,dmi_workitem w where delete_flag=false and dequeued_by is nullstring and task_state<>'finished' and event<>'dm_changedactivityinstancestate' and  name = USER and item_id=w.r_object_id and w.a_wq_policy_id='0000000000000000';

 

 

#Workflow Overview

#===============================================

select w.r_object_id, w.object_name as task_subject, w.owner_name as user_name, ' ' as task_details, w.tracker_state as task_state, w.start_date as date_sent, w.scheduled_end_date as due_date, 'Workflow' as object_type from d2c_workflow_tracker w where r_object_id in (select distinct w.r_object_id  from dm_relation r, d2c_workflow_tracker w where r.relation_name = 'D2_WF_TRACKER_DOCUMENT' and r.child_id = '0901819780922762' and r.parent_id = w.r_object_id) order by w.r_creation_date desc