Indices of page list
Experts,
What determines the indices of a page list ?
Page (1)
Page (2)
When we retrieve a page list in the clipboard, what determines which page comes on Page 1 and which one in page 2?
Posted: 4 years ago
We'd prefer it if you saw us at our best.
Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.
Well, it depends on the way you are retrieving data. Is it using Obj-Browse, ListViews, Report Definition? Are you specifying any sort order? In general, if you do not specify 'ORDER BY' clause in SQL query, RDBMS does not guarantee that your list will be returned in certain order. In PRPC, for instance, if you do not specify 'Sort' order in Obj-Browse, SQL query is generated without ORDER BY clause thus the order is never guaranteed. It may come in the order in which records are stored in disk or it may depend on how the table is indexed. It may even vary based on the columns being searched upon in WHERE clause.