GlideAggregate GroupBy giving Incorrect Count

[Sumit Pandey1]

Hi All,

When executing the below script, It shows me the count which is different from the count shown in list view with exact same query string! (Going to list view, and applying group by on Manager field).

I have already checked there are no Query Business Rules active on that table.

var myManagerList = [];
var getResourceManagers = new GlideAggregate('sys_user');
getResourceManagers.addEncodedQuery('active=true^company=c7af548d37323100d4e8daa543990e36^managerISNOTEMPTY');
getResourceManagers.addAggregate('COUNT','manager');
getResourceManagers.groupBy('manager');
getResourceManagers.query();  
while (getResourceManagers.next()) 
{
var manager = getResourceManagers.getAggregate('COUNT', 'manager');
myManagerList.push(manager);
}

gs.info('myManager length == '+myManagerList.length); //Output: 3757, List View Count: 3703

[Anish Reghu]

Just imagining if the array has some pre-stored value like the cache and needs to be flushed and recalculated for this task? Is it used elsewhere?

My question may be weird, but may point some clue.

[Sumit Pandey1]

Yes, the array length is more than grouped by number of manager records.

[DirkRedeker]

Hi

In your script, do you have several groups with only whitedpaces in it?

E.g. one group with one blank and another one with two blanks, etc?

Maybe that results in the different outcome.

Let me know.

BR

Dirk

[DirkRedeker]

Hi

Do you have any update on that?

Did you try out to investigate on my idea about this issue?

Just let me know, please.

BR

Dirk

[Sumit Pandey1 · Accepted solution]

Hi All, Thanks for your help. 

The real issue was - "When on a list and performing a 'Group By' action on a column, the row count that appears in the pagination may not match with how many rows are appearing on the page."

More information here - https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0720019

Thanks, Sumit