Queries. Return JSON formatted as JSONTYPE datatype parameter.

[isc-afuentes]

Currently queries avoids surrounding numbers and "_id" by double quotes in

Form.JSON.SQL:%DrawJSON

// to surround no numbers values and Id by quotes
Set:(($Isvalidnum(tOutVal)=$$$NO)||($ZConvert(tColName,"l")="id")||($ZConvert(tColName,"l")="_id")) tOutVal = $Char(34)_tOutVal_$Char(34)

This formatting is not the same as %JSON.Adaptor uses. %JSON.Adaptor relies on JSONTYPE datatype parameter.

For example:

%Library.String

/// JSONTYPE is JSON type used for this datatype.
Parameter JSONTYPE = "string";

%Library.Boolean

Parameter JSONTYPE = "boolean";

%Library.Integer

Parameter JSONTYPE = "number";