Useful Qeries: inbox task

I’ve a scenario whereby the user reported that he’d a task that is dormant and he wishes to delete but he couldn’t, also, the task is supposedly completed. So what I did was to check the dmi_queue_item table:

select * from dmi_queue_item where task_state = ‘dormant’ and sent_by = ‘Last Performer’ and task_subject like = ‘Task Name’

Once I located the entry, I update its delete_flag to ‘1’, rather than physically deleting the entry.

update dmi_queue_item objects set delete_flag = 1 where r_object_id = ”

This effectively removes the task from the user’s inbox.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: