Specifies how many elements of nested arrays are flattened into individual columns for report views.

Data Type

int

Default Value

0

Remarks

This property applies only to report views. It does not affect other tables.

When this property is set to 0 (the default), nested arrays are returned as JSON strings. When this property is set to a positive integer, that number of elements from each nested array is flattened into separate columns. The element index is appended to each column name.

When this property is set to -1, all elements in nested arrays are flattened into individual columns.

The following example shows how a nested array in report data is flattened:

["FLOW-MATIC","LISP","COBOL"]

When FlattenReportsArrayDepth is set to 1, the array above is flattened into the following columns:

Column Name	Column Value
languages.0	FLOW-MATIC

Flattening is only recommended for arrays that are expected to be short, as flattening large arrays can significantly increase the number of columns and reduce performance.

The nested values of non-primitive objects are returned as JSON aggregates. To access the values of those aggregates, you can use the JSON_EXTRACT function.