Sun Jun 20, 2021 9:40 pm
Login Register Lost Password? Contact Us

Sort on Enumvalues rather than data.

Questions around writing code and queries

Wed Apr 21, 2021 9:01 am Change Time Zone

Hi ALL ,
In case have to sort on enum values rather the column values as need is in specific order
and which has to be consistent and in control rather to be dependent on data.
Is there a way to sort

MyRec := {STRING3 Value1,STRING3 Category1, STRING3 Category2};
SomeFile := DATASET([{'NVS','T','ABC'},{'NVS','C','ABC'},{'A','X','BAC'},

srtvalues := enum(unsigned1,AAA, ABC, BAC,AAC,PQR);
//need to sort on values of 3rd field which is static but can add latter
Srtd_values_ds := sort(SomeFile,srtvalues.AAA);
Posts: 26
Joined: Fri Feb 23, 2018 8:30 am

Return to Programming

Who is online

Users browsing this forum: No registered users and 1 guest