How Do I write in to this expression - sort by alphabetic order?

[Tiger1]

<<Start: SELECT(GEOFORCE[Newcomputedkey], AND(NOT(CONTAINS([LAST SEEN LOCATION], “Victoria”)), [location] = “59-01”,[VC Item Status] = “ready”,ISNOTBLANK([GPS TAG])) TRUE)>><<[Asset ID]>>

The column I need ordered is [Type]

Thanks

[Aurelien · Accepted solution]

Hi @Tiger1 

<<Start: ORDERBY(SELECT(GEOFORCE[Newcomputedkey], AND(NOT(CONTAINS([LAST SEEN LOCATION], “Victoria”)), [location] = “59-01”,[VC Item Status] = “ready”,ISNOTBLANK([GPS TAG])) TRUE),[columnName],FALSE)>><<[Asset ID]>>

For reference:

ORDERBY() 

Use Start expressions in template (section: Control the record order)

[Tiger1]

Worked PERFECTLY!

Thanks

[Tiger1]

I meant to also ask - can you order within an order?

In other words - I want order by [Type] then within the [type] I want [Item_description] ordered?

[Aurelien]

You may want to have a look to the documentation 😉

...but the short answer is yes