6.1.5 Working with Multi-Value Columns

If a facet's filtered column potentially stores multiple values in each row, then set the Multiple Values property to either Delimiter or JSON Array. Once selected, additional options appear.

The Trim Whitespace setting removes space, tab, or newline characters from the beginning and end of the values. The Filter Combination property decides if a row matches when:

• any contained value matches some filter option – OR (Union), or
• only when the contained values match all filter choices – AND (Intersect).

For example, imagine the EMP table had an additional column INTERESTS of type VARCHAR2(1000) storing multiple values using the colon character as a delimiter. Assume employee SMITH has the following value for this column:

Art:Animation:Urban Sketching:Math

If you configure a P23_INTERESTS facet with colon as the multi-value delimiter and a filter combination setting of AND (Intersect), then SMITH will match when the end user selects both "Animation" and "Math" group filter options, but employees with INTERESTS containing only Art or only Math will not match.