/bundles/itninjaweb/img/Breadcrumb_cap_w.png
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   [ - ] Hide Comments

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.
Answer this question or Comment on this question for clarity

Answers

0
The OWNER_ID value for Unassigned is 0.

SELECT * FROM HD_TICKET T
WHERE T.OWNER_ID = 0
Answered 06/23/2010 by: airwolf
Tenth Degree Black Belt

Please log in to comment
0
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
0
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