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

[Deep_Foundation]

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_KULACOGL]

@Deep_Foundations you can use ORDERBY expression with REF tables only

[Deep_Foundation]

@Levent_KULACOGLU

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

[Levent_KULACOGL]

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

[Aleksi_Alkio]

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

[Deep_Foundation]

@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]

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.