MV Property Filtering

The valve is used to filter out values from a multi-value property. The values are stored as a new multi-value property or as a CSV string.

Configuration

Note

Valve name: MVPropertyFiltering

Properties

Name	Description	Default	Mandatory	Expanded
src	Name of the existing item property OR an expandable string.	N/A
dest	Name of destination property.	N/A
include_patterns	Patterns to include (supports *, *x , *x* , x* ). Empty array includes all values.	[]
use_csv	if true, write CSV string to dest. If false, the filtered values are written as a multi-value property.	false
csv_separator	CSV separator when use_csv is true	","

Example

Read an item property by name:

{
    "name": "MVPropertyFiltering",
    "enabled": true,
    "config": {
        "src": "memberOf",
        "dest": "groups",
        "include_patterns": [
            "Users*",
            "*ompu*",
            "*users"
        ],
        "use_csv": false,
        "csv_separator": ","
    }
}

Read values through an expansion expression:

{
    "name": "MVPropertyFiltering",
    "enabled": true,
    "config": {
        "src": "@json:${exports.memberOf.all}",
        "dest": "groups",
        "include_patterns": [
            "Users*",
            "*ompu*",
            "*users"
        ],
        "use_csv": false,
        "csv_separator": ","
    }
}