JSON_ARRAY
Returns the listed values. The list can be empty. Array values must be of type string, number, object, array, boolean or null.
Syntax
<JSON array constructor> ::= “JSON_ARRAY “(“ [ <JSON value expression> [ { “,” <JSON value expression> }... ] [ "NULL ON NULL" | "ABSENT ON NULL" ] ] “)”
Rules
1. Return type is String;
2. ABSENT ON NULL is implicit;
3. Query expression is not supported: JSON_ARRAY "(" <query expression> ")", create an view with required tabular data is a natural way to reach this objective.
4. Besides numeric, boolean, null types, JSON values should be string or cast as string.
Examples
SELECT * from /shared/examples/ds_orders/tutorial/customers ORDER BY JSON_ARRAY ()
SELECT a.customerid, a.CompanyName from /shared/examples/ds_orders/tutorial/customers a INNER JOIN /shared/examples/ds_orders/shippingmethods b ON '[]'=JSON_ARRAY()