Hi Everyone, I'm a new outsystems developer.
I have a main page with few tables, I would like to associate a Aggregate for each table, its mean that I need to have a different filter for each table.
I tried with Events On sort configuring a Refresh data, but its doent work.
You should go through the Reactive Web Developer course.Here are some parts of the course related to your issue:1. Aggregates 1012. Building Screens with Data3. Pagination and SortingThanksGitansh Anand
Hi Fernando,
the best way to do it is using a different aggregate to each table, so you can apply different filters to your tables
Kind regards,
Sergio
Hi Fernando, I am adding an OML; please see if it helps you.All you need to do is drag the entity directly to your screen, and OutSystems Accelerator will do the work for you.ThanksGitansh Anand
Do keep in mind when I say Accelerator will do the work that it will only create the pagination and dynamic sorting logic; you will need to add other sources, joins, and filters as required.
You can join multiple tables in a single aggregate with appropriate joins and you can have multiple filter conditions as well on the individual tables. Hope this helps your requirement.
Happy coding!
Mathavan
@Sergio Aznar Guallar @Gitansh Anand @Matthias Sevenant
In the screenshots has what I doing.
I configured differents sources for each table.
Do I need to create a Variable's structure as the screen1?
what is the logic to do this?
Thank you
Yes, for each table, you should keep separate variables for sorting and pagination.
You should use separate variable for every table aggregate used on the screen like TableSort, StartIndex and MaxRecords(If required) and also separate actions for sorting and Pagination.So, that they will not distrube each other.
RegardsKrishnanand Pathak
Thank you ! I got it, I dont understant pretty good but its working.
I will post a new question, please help me to improve it!
thanks again.