Are keys returned in the order of addition?

Solved379 viewsdriver development primary key SLScripting
4
0 Comments

Hi everyone,
if we were to retrieve a table's primary keys via the getcolumn notify, are the returned keys in the order of how they were added into the table? Or is it completely random?

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 27th January 2025

1 Answer

5
12.93K 0 Comments

Hi,

When retrieving primary keys you should not assume they come in any specific order.

Ordering is only done when displaying the data to the user.

The only guarantee is that if you retrieve multiple columns at the same time the returning data will have the same order between each retrieved column.

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 27th January 2025