Hello,

Can you share screenshots of the code?

Hello vn_perpetuo, 

Check the following links, I feel you aren't doing pagination right :) 

• https://success.outsystems.com/documentation/11/developing_an_application/design_ui/patterns/using_mobile_and_reactive_patterns/navigation/pagination/
• https://www.outsystems.com/forums/discussion/56822/reactive-web-application-paginate-a-table-with-an-advancedsql-source/
• https://success.outsystems.com/documentation/how_to_guides/front_end/how_to_use_the_dropdown_search_to_filter_an_aggregate_with_a_list/

Best regards, 

Ana

Hey @vn_perpetuo ,

I have create a sample pagination demo where I am filtering the table based on Country Id(726).

I am attaching an OML. I hope this will help you!

Have a good day!

Thanks & Regards,

Sudip Pal

Hello @vn_perpetuo 

Here is the good post from @Kilian Hekhuis  where he had explained very well the pagination, sorting with example while data has been fetched by data action. Please refer this blog for your issue resolution.

https://itnext.io/paginating-sorting-and-filtering-data-from-a-data-action-f5cb997fdc60

Thanks,

Sachin

Hi @vn_perpetuo hope You're well!

I think there's a misunderstanding on how to use the page variables (StartIndex and PageSize). Passing the updated values to the loop in Paginacao will probably not work because the data action doesn't seem to have been run again with the updated page values.

The updated page values have to be sent to the action that gets the data.

So, I understand you have a DataAction1 object attached to your screen. I guess this Data Action is getting its data from Get_Lote_Objeto Service Action.

What I guess you should be doing is:

1. Create variables to hold the values of StartIndex and MaxRecords, with default values to 0 and whatever page size you want. That would define your first page settings
2. Make sure your DataAction1 calls your Service Action (Get_Lote_Objeto) passing the values of those variables, along with your filters
3. In the FiltrarOnClick you should do a refresh on your data action instead of calling Get_Lote_Objeto. Simply drag DataAction1 to your FiltrarOnClick action and remove the reference to Get_Lote_Objeto. That will refresh your DataAction bringing the first page result (remember it will be referencing your page variables with those default values)
4. I also understand the action Paginacao is the one answering your pagination events. If so, this action should:
   • Update your page variables according to the pagination event (i.e. NewStartIndex)
   • Do  another refresh on your DataAction. This will run the action with the updated page values, bringing the new result page
   • Get and use the new page result from the data action

I hope I have been able to understand your question and been of some help.

Good luck and best regards!

Hi, thanks for everyone's help. 

I was doing the pagination and filtering as I observed in the outsystems documentation and with the help of the forums, but something was still going wrong. After observing everything carefully I realized that the error was in my DataAction. I was passing current.result to the values of my data action, so I changed it to local variables (which were the ones that received the filter), so the Refresh DataAction worked and maintained the pagination.