Paginating Fetch Entities Step?

Unknown

Paginating Fetch Entities Step?

Unknown

[font=Roboto, Arial, Helvetica, sans-serif]Hi, I know about the fetch entities step but in my understanding, it fetches all entities of a given type (depending on filters). I also know the Query Editor may support the TOP parameter but it return record, not entities. Is there any solution to fetch entities but only a certain amount and start from an ID so I can do pagination? This requirement is for an integration, not for showing on a report.[/font]

Unknown

[font=Roboto, Arial, Helvetica, sans-serif]Its possible to limit the number of objects returned by using logic in a flow to create a new list with X objects from the result list of a Fetch Entities step. A similar process could be used to mimic pagination, but it would require multiple hardcoded lists.[/font]
[font=Roboto, Arial, Helvetica, sans-serif]
[/font]
[font=Roboto, Arial, Helvetica, sans-serif]Alternatively, Stored Queries and Raw SQL steps support the top keyword and parameterization. If either were used, it opens up more possibilities for solutions to this in a flow. If the flow started with a Raw SQL step or Stored Query, you could more easily limit the number of results or return results between ID X and Y. By using a Converter Flow, you could translate the results of these steps directly to your desired type, or only query for IDs and get each item individually. [/font]
[font=Roboto, Arial, Helvetica, sans-serif]
[/font]
[font=Roboto, Arial, Helvetica, sans-serif]As long as the table you are querying directly correlates to a type (both built-in and user-defined) in Decisions and returns each column, a converter flow is not required for the output of Stored Queries. Instead, the type itself can be selected as the Stored Querys output type. (A) If your intention is to return a user-defined type, its table name can be found by editing the types definition. (No changes need to be made to the type itself) (B) I have added a Stored Query to the example I sent earlier that performs the same function as earlier versions of the example. Please feel free to modify it as you like.[/font]