Anyone know if there is a way to get the order of ...
# suiteqlc
Cory Weiner
05/13/2022, 3:37 PMAnyone know if there is a way to get the order of a list via SuiteQL?
j
jen
05/13/2022, 3:38 PMWhat is that screenshot a list of?
c
Cory Weiner
05/13/2022, 3:38 PMIt’s a custom list
j
jen
05/13/2022, 3:38 PMJust a Custom List?
jen
05/13/2022, 3:38 PMk
c
Cory Weiner
05/13/2022, 3:39 PMYou can sort the list in the UI, which adjsuts how it shows in dropdowns. but I can’t figure out if it’s posisble to get the same ordering when accessing the list via SuiteQL
j
jen
05/13/2022, 3:40 PMis it not just in order by the ID?
jen
05/13/2022, 3:40 PMoh I see what you mean
c
Cory Weiner
05/13/2022, 3:40 PMIt’s not.
j
jen
05/13/2022, 3:46 PMmust be stored elsewhere, but I can’t even see anything in ODBC either
m
Matt Bernstein
05/13/2022, 4:30 PMyou have the list set as the ordered entered? I don't believe so easily. depending on you use case, you might be able to manipulate the scriptid to be in the order you want it.
c
Cory Weiner
05/13/2022, 4:31 PMYeah I’m going to end up using the externalid field as a sort order field. It’s just a bummer because surely netsuite is storing this data somewhere.
m
Matt Bernstein
05/13/2022, 4:32 PMyeah i'm with ya. one of the things they don't give us access to