Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

filter for unassigned tickets not showing exact number

Micky6002
Tera Expert

I created filter under Task table to show all the assigned & unassigned INCs and Tasks to service desk.

the conditions are:

Assignment group is A or B or C

Assigned to is agent 1 or agent 2 or agent 3 or is empty

Active is true

State is not resolved.

Background: there are many agents in the group, but I want to see the tickets assigned to some of agents only.

 

The problem is when I run this filter, the "empty" always show wrong number than actual. 

that is to say it shows "Assigned to empty(15)", but only 1 unassigned ticket listed below.

so what is wrong with my filter? I appreciate someone can advise me about it.unassigned.png

1 ACCEPTED SOLUTION

Hi Shubham;

I'm still able to see 1 record only after opening in a new tab.

but the count for "empty" queue seems to show correct amount after I added conditions "Task type is Incident or Catalog Task".

Anyway I thank you for your answer!

View solution in original post

2 REPLIES 2

Shubham_Shinde
Giga Guru

Hello @Micky6002 ,

Try opening the records in a new tab like below and check if you are able to see 15 records or still one record only:

Shubham_Shinde_0-1676355669636.png


And if you're still able to see only one record then there's this KB article which I came across which states that "If you're grouping by on a column where there are empty values, these rows are grouped but not treated as a row count within the pagination.". Please find this article link for your reference: KB0720019 

If my answer has helped with your question, please mark it as correct and give it a thumbs up!


Regards,

Shubham

Hi Shubham;

I'm still able to see 1 record only after opening in a new tab.

but the count for "empty" queue seems to show correct amount after I added conditions "Task type is Incident or Catalog Task".

Anyway I thank you for your answer!