BUILD_CONDITION Function

Parameters: (String, String, String);

Returns: String;

Function to build a condition expression based on a set of fields and values.

Conditions generated are intended for use on a ServiceNow target servers ONLY.

The first parameter is a comma separated list of field names.

The second parameter is a comma separated list of field values.

The third parameter is the ServiceNow conditional operator to be used.

The values in the lists may be delimited using a double quote (") character.

The lists of fields should have the same length as the list of values, or be a single value (which will be repeated).

Empty values are shown as an empty string.

A maximum of 100 values are supported.

Example:

    BUILD_CONDITION('"field1","field2","field3"','"value1","","value3"','^'

Result:

    field1=value1^field2=^field3=value3