Can someone tell me how to filter for 'Unassigned' tickets? It does not work to include 'un' in my REGEX expression because the 'OWNER_ID' value is null for unassigned tickets. As it is now, because I'm monitoring the entire queue, I simply look for all tickets that do not have a status of 'Closed'. I would, however, like to be able to filter unassigned so my techs can see them. I'm sure I'm missing something simple and just need a slap on the side of the head to find it.
0 Comments   [ + ] Show Comments


Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.


The OWNER_ID value for Unassigned is 0.

Answered 06/23/2010 by: airwolf
Tenth Degree Black Belt

Please log in to comment
Similar to this post
You can do the following in the advanced search field

OWNER USER NAME does not contain _

(that's "underscore")
Answered 06/23/2010 by: GillySpy
Seventh Degree Black Belt

Please log in to comment
Thanks Andy and Gerald.

Andy, I knew the ID for Unassigned was 0, but can't use a Select query as a ticket filter (that I know of). Therefore, your query, as excellent as it is, won't work for filtering tickets.

Gerald, your suggestion worked great. I never realized that could be done with the underscore. Thanks for that.
Answered 06/23/2010 by: terabyte
Orange Belt

Please log in to comment
Answer this question or Comment on this question for clarity