ORDER BY not working in a SQL table query?

[craig_dickson]

[ FlexSim 23.0.2 ]

I am using a table query with SQL and it doesn't seem to be using the ORDER BY clause. What am I dong wrong?

Here is the query:

Table tableBestLocation = Table.query("SELECT * FROM $1 ORDER BY 'CycleLastUsed' ASC LIMIT 600",Table("tableStorageStatus")); //
tableBestLocation.cloneTo(Table("QueryDump"));

Here is the searched table:

And her is the result table:

With the

ORDER BY 'CycleLastUsed' ASC

I expected (and wanted) the first row in the result to be LocationIndex 2, since its value of CycleLastUsed is lower than that of the first record. (Note that I am looking for the lowest, which may not be zero after a while.)

[jason_lightfootVL7B4 · Accepted solution]

You don't need the apostrophes around the field name - try without and it should work fine.

[andrew_o2]

Hi @Craig DIckson, was Jason Lightfoot's answer helpful? If so, please click the "Accept" button at the bottom of their answer. Or if you still have questions, add a comment and we'll continue the conversation.

If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always unaccept and comment back to reopen your question.