Row Level Filtering

Overview

Each External Object can have a single row level filter applied, which restricts records to a subset that match some User attribute.

This will add an automatic WHERE clause to the database query, of the form

<column name> <operator> <salesforce operand>

This clause is automatically applied, regardless of any other filtering occurring on the object.

Row Level Filtering is configured in the Setup UI, under the "Omnata Connect" tab.

Operators

The following operators are supported:

= (equality)

The value of the Salesforce operand must match the value in the database column. The data type of the Salesforce operand should be comparable to the data type in the database.

includes

The value of the Salesforce operand must appear in an Array column. This operator is only supported in Snowflake and Rockset, and can only be used with array columns.

arrays_overlap

The value of the Salesforce operand will be split into an array on the ';' character, and Multipicklist fields are a good choice as they are automatically delimited on this character. This operator is only supported in Snowflake and Rockset, and can only be used with array columns. The row will be visible if the two arrays share at least one value in common.

Boolean operators

AND: Both the Salesforce operand and the database column must be boolean. The following truth table determines whether or not the row will be visible:

Database	Salesforce	Row Visible
TRUE	TRUE	Yes
TRUE	FALSE	No
FALSE	TRUE	No
FALSE	FALSE	No

OR: Both the Salesforce operand and the database column must be boolean. The following truth table determines whether or not the row will be visible:

Database	Salesforce	Row Visible
TRUE	TRUE	Yes
TRUE	FALSE	Yes
FALSE	TRUE	Yes
FALSE	FALSE	No

XOR: Both the Salesforce operand and the database column must be boolean. The following truth table determines whether or not the row will be visible:

Database	Salesforce	Row Visible
TRUE	TRUE	No
TRUE	FALSE	Yes
FALSE	TRUE	Yes
FALSE	FALSE	No

NAND: Both the Salesforce operand and the database column must be boolean. The following truth table determines whether or not the row will be visible:

Database	Salesforce	Row Visible
TRUE	TRUE	No
TRUE	FALSE	Yes
FALSE	TRUE	Yes
FALSE	FALSE	Yes

NOR: Both the Salesforce operand and the database column must be boolean. The following truth table determines whether or not the row will be visible:

Database	Salesforce	Row Visible
TRUE	TRUE	No
TRUE	FALSE	No
FALSE	TRUE	No
FALSE	FALSE	Yes

Operands

The left hand side is always just the value in the specified database column.

The right hand side is evaluated in Salesforce per query, in the context of the user. It can be:

• User attribute: An attribute of the current User

• User is member of Public Group (directly): A boolean value indicating whether or not the current user is a member of a Public Group. "Directly" means that the user must be directly assigned to the group, not another group which belongs to this group.

• User not member of Public Group (directly): A boolean value indicating the inverse of the above; whether or not the current user is not a member of a Public Group.

• User is assigned Permission Set: A boolean value indicating whether or not the current user has been assigned a particular Permission Set.

• User not assigned Permission Set: A boolean value indicating indicating the inverse of the above; whether or not the current user has not been assigned a particular Permission Set.