Support Adobe's settings for JSON serialization

I have implemented the following:

SerializeJSON( myQry, [ "row" ] | "column" | "struct" | true | false );

this.serialization.preserveCaseForStructKey = false | [ true ];

this.serialization.preserveCaseForStructKey = [ false ] | true;

this.serialization.serializeQueryAs = [ "row" ] | "column" | "struct";

I have not implemented this.serialization.structMetaData as it should be implemented with the new function StructSetMetaData (see LDEV-1809) as that function can override the global settings. The documentation at https://helpx.adobe.com/coldfusion/cfml-reference/coldfusion-functions/functions-s/serializejson.html (struct value) is inconsistent with the one at https://helpx.adobe.com/coldfusion/cfml-reference/application-cfc-reference/application-variables.html (simple value).

I have not implemented this.customSerializer as it clashes with our current API and TBH I'm not sure what it's supposed to do.

New tickets can/should be opened for the last two items.

In https://helpx.adobe.com/coldfusion/cfml-reference/coldfusion-functions/functions-s/serializejson.html

To enable case preservation of struct keys at the application level, modify the application.cfc file by setting:
this.serialization.preservecaseforstructkey = true

The default behavior is true. To switch back to the old behavior, set this value to false.

But according to https://helpx.adobe.com/coldfusion/cfml-reference/application-cfc-reference/application-variables.html the default value is False.

The quoted text above is more consistent with Lucee so I've set it to that until and unless we determine that a change is required.

For Query serialization with a string argument, the following options are available:

default - "row", overridden by this.serialization.serializeQueryAs="struct"

false, "row" - false is implemented, need to add "row" as alias

true, "column" - true is implemented, need to add "column" as alias

"struct" - added in

Thanks for the heads-up, . I've tagged this for a future sprint, and I see upped the priority to Critical, too.

This will definitely help me. I'm about to transition a very large app from ACF2016 to Lucee and there are a TON of DATATABLES (datatable.net) in it. The native conversion to an array of structs is exactly what I need.

Now, any chance this same functionality has made it over to remote CFCs? (Where returnFormat=JSON and returnType=struct would return the json formatted array of structs that ACF does)