Question

1
Replies
309
Views
 Dyan Baur (DyanG412)
Hawaii Medical Service Association

Hawaii Medical Service Association
US
DyanG412 Member since 2013 212 posts
Hawaii Medical Service Association
Posted: June 4, 2016
Last activity: June 6, 2016
Posted: 4 Jun 2016 18:02 EDT
Last activity: 6 Jun 2016 3:38 EDT
Closed
Solved

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?

Data Integration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 5 years ago
Posted: 6 Jun 2016 3:38 EDT
Vikas Raidhan (VikasRaidhan)
PEGA
Manager, Multi Channel Dev
Pegasystems Inc.
IN

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.