How is your experience with the OutSystems Community?
22
Views
3
Comments
With Outsystems Datagrid , need to access 100k records

hi all, With Outsystems Datagrid , need to access 100k records , the problem is the filter is working with the current data showing in the page  , need to acces it with the  whole records in the table , 

2024-07-05 14-16-55
Daniël Kuhlmann
 
MVP

Hi,

Your question is very high over with details of what you tried, where you got stuck.

If you want people to help you effetively you need to provide more information.

Regards,

Daniel

2026-07-23 14-34-51
Nuno Reis
 
MVP

Hello.

Without more information and from what you wrote, my diagnosis is:

Aggregate for the table has MaxRecords and the same aggregate was used for the DataGrid. That's why you only see the "data showing on page".

You need to give it the full dataset in the Entity, not what the table widget can display.

2026-03-13 15-51-13
Samuel Espinoza

Hello, since there are no further details, I believe this might be the issue is also another possibility. I’m not sure if you are using this logic. With that you can handle the Filters in the Grid.
And with that action you can trigger a DataAction or an Aggregate depending what you're using for the Grid Data so you could go and filter from those 100k Records. This is another option in case you don't have the full list of Items available and you need to do more logic.


Good luck

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.