How to include the startIndex and MaxRecords variables on the DataAction aggregate? I'm using an action that runs through the aggregate and appends the items that correspond with this condition (CurrentRowNumber >= StartIndex and OutputList.Length < MaxRecords), it works but i'm asking if there's a more efficient way of doing this.
Thank you guys :) :)
Hi Ricardo Sousa Carvalho
You can try using advanced SQL. Check this thread: https://www.outsystems.com/forums/discussion/56822/reactive-web-application-paginate-a-table-with-an-advancedsql-source/
Regards,
Gonçalo Almeida
Resurrecting this thread to say... that's just unacceptable. Why is there no start index?
@Mariano Picco Start index is there. Please check for OFFSET in the query.
Cheers!!
I don't think we're talking about the same thing. Offset is all good for SQL but not all data actions use SQL queries
Hi Ricardo,
The Paginating, sorting and filtering data from a Data Action article covers precisely this topic and in addition the Paginating Data Action Example forge component shows how it is done.
Kind Regards,João
Hello,
I have table list retrieved from API response data action and make the solution of append on another list but the problem that the table show only the first record, any suggest?