I have a SELECT in suggested values, which works:
SELECT(Wood chop orders for App SQL version.csv[Moulding Code],[Product Code]<>COM)
I want to order it by the product code, but ORDERBY is not working.
ORDERBY(SELECT(Wood chop orders for App SQL version.csv[Moulding Code],[Product Code]<>COM),[Product Code])
I can’t work out what is wrong
ORDERBY() works on ordering row keys. Is [Moulding Code] a table key?
I see. [Moulding Code] isn’t a key.
Is there any way to order non Keys in a select list?
I think you will need an additional column for the same. Please try adding a virtual column
[OrderByProductCode]
ORDERBY(SELECT(Wood chop orders for App SQL version.csv[Key Column],[Product Code]<>COM),[Product Code])
Then suggested values could be
[OrderByProductCode][Moulding Code]
Brilliant, thanks
