Hi, How to do an OrderBy on a table without ...

references
(Deep Foundations) #1

Hi,

How to do an OrderBy on a table without the reference key column?

I have a table which has a key column called “Unique ID” and another regular column called “Names”. I would like to only show the “Names” column in descending order without having to show the “Unique ID” column.

Thanks

(Levent KULAÇOĞLU) #2

@Deep_Foundations you can use ORDERBY expression with REF tables only

(Deep Foundations) #3

@Levent_KULACOGLU

Is there any work around or a different approach? I really need to have it descending in one of my apps.

(Levent KULAÇOĞLU) #4

@Deep_Foundations AFAIK, there is no work around for that. But we may consult @Aleksi_Alkio also.

(Aleksi Alkio) #5

Am I correct that you want to show that order on a table view? You are not talking about the dropdown at all?

(Deep Foundations) #6

@Aleksi_Alkio I have an enum list quick edit that has a valid if to show the column (not a reference column) in descending order.

(Aleksi Alkio) #7

Unfortunately the ORDERBY won’t work. It’s meant for the ref fields only. One kind of SORT expression is in pipeline, but not ready yet.