Group by filter is not able to show all information

[rafas_10]

Hi all,

I hope you're doing well.

I've made a filter on my record producer variables and the filter is good, the information displayed is not. It is not showing me all the values once I do group by:

Once I move from the next page, it immediately moves for page 21 but only shows records until letter E.

I have a form named Payroll Requests that should appear on this group by and once I search it on the filter, it appears, so the question here is: Why is the group by filter limited:

Thank you for the help!

EDIT: I edited the order of the filter and more appear but not all. Question maintains why not all appear and why order of the filter matters if it's all conditions AND?

Kind regards,

Sérgio

[prajaktajga]

Hello @rafas_10 ,

I think this is the normal behavior of ServiceNow sometimes it will happen
When you click Group By, ServiceNow executes something equivalent to:

SELECT DISTINCT field FROM table ORDER BY field

[Ankur Bawiskar]

@rafas_10 

this is platform OOTB behavior

my thoughts

-> ServiceNow paginates and groups reference field records based on the "Items per page" UI property. If set to 20, only the first 20 records per group are displayed, regardless of the total matching records.

-> When scripted filters or before-query business rules apply, condition order can affect results—especially if rules aren’t strictly AND-based or conflict with filters. Rearranging filters may show more records, but not all.

check these links for reference

Grouped lists 

The users see different number of records based on sorting order in the list view. 

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏