Pagination with OLEDB

Discussion created by andyromero on May 20, 2014
Latest reply on May 26, 2014 by andyromero

We need to query the pi database to retrieve page of results, eg there´s a need to create a query that performs pagination.


In sql server we have a ROW_NUMBER() function that helps in this type of functionality, similar Oracle has rownumber pseudocolumn.


Is there any example of such query or any clue that could help me write that query using pi-olebd?




Thanks for any help