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
@Deep_Foundations you can use ORDERBY expression with REF tables only
Is there any work around or a different approach? I really need to have it descending in one of my apps.
@Deep_Foundations AFAIK, there is no work around for that. But we may consult @Aleksi_Alkio also.
Am I correct that you want to show that order on a table view? You are not talking about the dropdown at all?
@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.
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.
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |