Virtual Column OrderBy I want to order a VC ...

(Fabian Weller) #1

Virtual Column OrderBy

I want to order a VC by using (OrderBy(Select(…) , [DateTime] , FALSE). But in fact it does not order by the DateTime column. Is OrderBy not working for VC?

(Suvrutt Gurjar) #2

Hi @Fabian, As per documentation and my quick testing, the ORDERBY expression works on ref list expressions (list of row keys).

However I will request senior colleagues @Aleksi_Alkio, @Philip_Garrett_Appsh for their inputs.

Please go through “Sorting a List of Keys with ORDERBY” section

help.appsheet.com - List Expressions and Aggregates List Expressions and Aggregates help.appsheet.com

(Aleksi Alkio) #3

Yes that’s true.

(Suvrutt Gurjar) #4

Thank you @Aleksi_Alkio for the guidance.