Filtering A queue with an insight field is None

[Steven LS]

Hi there,

I am building a little catch all queue to grab issues that come in that might not be caught by some automation.  The automation is built around populating an Insight custom field called "Queue".

When that has no value it displays as None.  Not sure what IQL to put in to filter for that value to be None, so the queue only shows those issues.

Name = "None" doesn't work in the way that the filters that are set up to capture the Queues that are populated do.

i.e. Name = "Service Operations" will display those issues nicely in a queue.

It's odd, I have two test tickets one has a Queue value of Service Operations and the other has a value of None

If I put in the "Run IQL Search" box Name != None, it only shows the issue with Service Operations in the queue field.  If I put Name = None, nothing shows up at all... I would expect the queue with 'None' as the value to show up.

How do I capture the 'None' value in the little IQL box that comes up in the queue filter.

[Steven LS · Accepted solution]

Turns out even though it's an insight field and when you add it to the filter you get the little Run IQL box, you can ignore it and just type JQL into the Advanced view.

Queue is EMPTY was all I needed to type and not worry about the IQL anything.