ArrayMode
How fields that contain array values are presented.
Possible Values
Flatten, ChildTablesData Type
string
Default Value
"Flatten"
Remarks
Domino allows fields within a database to have multiple values within each row. Some types of form elements allow this (for example, checkboxes or listboxes) as well as multiple form elements bound to the same field. The driver detects these fields and displays them differently based upon this option.
By default, the Flatten mode is used, which combines all the values in the field
into a single text value. For example:
SELECT colors FROM Notes /* colors ------------------------ ["red", "green", "blue"] */
If the ChildTables mode is used instead, each multi-value field is moved from
its main view into a separate view. These views contain multiple rows per
unique note identifier and can be JOINed back to the main view to get all the
values of a multi-value field. For example:
SELECT Notes.[@unid], Notes_colors.[@offset], Notes_colors.color FROM Notes INNER JOIN Notes_colors ON Notes.[@unid] = [Notes_colors].[@unid] /* @unid @offset color ----------------- --------- ----- 01234567890ABCDEF 1 red 01234567890ABCDEF 2 green 01234567890ABCDEF 3 blue */