Order by syntax with structure

[Dale]

I've created the below query result with a deserializejson function.

What is the "order by" syntax in a cfquery if I want to sort by the status, struct, value?

Thank you,

Dale

Query Execution Time: 0.322 ms Record Count: 1 Cached: No Lazy: No SQL: SELECT * FROM recordset2

name

id

type

description

module

status

createdBy

serviceProviderCode

openedDate

trackingId

customId

jobValue

value

1

ADAMS SEWER

SANLEANDRO-DUB15-00000-00156

Struct module string Building value string Building/OTC/Residential Sewer/NA type string OTC text string Residential Sewer group string Building alias string Residential Sewer subType string Residential Sewer category string NA id string Building-OTC-Residential.cSewer-NA

REPLACE SEWER LINE FROM HOUSE TO MAIN LOCATED AT REAR OF DWELLING.

Building

Struct value string Issued text string Issued

CCUERO

SANLEANDRO

2015-07-31 00:00:00

200767209

B15-0988

8000

DUB15-00000-00156

 

[Peter Boughton]

JSON doesn't know anything about queries, so deserializeJson would not be outputting a query (unless it has a bug).

Queries are designed to handle simple variables - whilst arrays/structs/queries can be stored inside query cells, I don't think there's any specific support for it in QoQ, and I doubt there's any SQL ORDER BY construct that'll handle it.

For a concrete answer, you'd want to either read through the source and figure it out, or ask a developer. Of course, all Railo developers (and community) switched across to Lucee (http://lucee.org) so you'll need to go ask on the Lucee mailing list, where Micha/Igal may be able to provide an answer.

Most likely the advice will be to either separate the struct keys out into separate query columns and sort on those, or just use an array/struct combo then do the sorting with ArraySort and a suitable comparison function.