Filter for 'Unassigned'
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
Answers (3)
Please log in to answer
Posted by:
airwolf
14 years ago
The OWNER_ID value for Unassigned is 0.
SELECT * FROM HD_TICKET T
WHERE T.OWNER_ID = 0
Posted by:
GillySpy
14 years ago
Similar to this post
You can do the following in the advanced search field
OWNER USER NAME does not contain _
(that's "underscore")
You can do the following in the advanced search field
OWNER USER NAME does not contain _
(that's "underscore")
Posted by:
terabyte
14 years ago
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.
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.
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.