Question & Answer
Question
Can Primary key of the tables be used for sorting based on creation time in IBM Sterling Order Management?
Answer
Primary key is a combination of timestamp and sequence number. When the number of records increase in the table then sequence number also increases. This translates to a change in key length from 21 to 22, so on and so forth.
In most cases the primary keys and the createts are ordered the same way. However you also have the option to randomize any table by adding KeyType="Random" in the entity xml. This could clash with the order of the time stamp
Starting from version 9.2, the application allows some tables to be randomized by default. In addition to this there is an option of generating custom primary keys as well.
If you are certain that the Primary key generation for table YFS_CHARGE_TRANSACTION is not randomized or custom generated and if you do not have any plans in the future to make any change to this, you can sort by Primary Key.
The application already provides the createts field which will help to sort with creation time, it is recommended that you use the same column instead of the primary key column.
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21684075