I have a simple search:
Status = ‘Active’ AND Priority != ‘Low’
and yet the results include tickets with Low priority. What am I doing wrong?
To answer my own question:
The priority must be expressed as an integer via the Advanced Query editor. Using the query builder always adds the priority as a string which won’t work.
1 Like
Nice catch! I ran into this exact thing a while back. It’s definitely one of those quirks where the Query Builder feels like it should handle the string conversion automatically but doesn’t. It’ll definitely save someone else a headache!