query runPaged does not allow Order By clause:pens...
# suiteql
z
query runPaged does not allow Order By clause😔.. bug
e
If I run this query in a restLET, would it then work? With the N/query module?
z
AFAIK no, I am using only restlet and MapReduce script and have the same issue. Additionally, I found bug with nested sekect in select for example: select a.field, (select b.field from b where a.id = b.id) as x from a It works only with query. run, not with query runPaged
You might just have to specify asc or desc (ascending or descending) at the end