Worker Query - Worker Queue ID value
Updated: 21 May 2010 | 1 comment
I basicly want to combine the canned query for Incidents open to interactive worker and incidents open to the workers queue.
the canned query finds the interactive worker using the where clause of:
workitem_owned_by_worker_id = $current_worker_id$
I'd like to add in incidents that are assigned to the workers default queue. I know how to staticly create it but I wish to dymanicly call it so I don't have to create a query for each possible queue.
discussion Filed Under:
Comments
Hi,
Give this a try. I can't really test here so...
(workitem_owned_by_worker_id = $current_worker_id$ or workitem_assigned_to_worker_id = (Select queue_id from Worker Where id = $current_worker_id$))
and workitem_status_lookup_id = 300
The above *should* give you the open tickets owned by the current worker and the tickets assigned to the currect workers queue.
Dan
Would you like to reply?
Login or Register to post your comment.