Filtration syntax for User Profiles (On-Premises)

SharePoint Org Chart allows to filter employees using conditions. Conditions are similar to SQL language. You can specify filtration rule in the configuration wizard, see Org Chart filtration documentation for details.

You can create conditions based on User Profile properties. On this page below you can find the list of available operators and values you can use in your conditions.

Operators

Logical

These operators can do some logical comparison between other expressions:

Operator Description
or

TRUE if either Boolean expression is TRUE.

Example:

[Department] = 'Marketing' or [Department] = 'Support'
and

TRUE if both Boolean expressions are TRUE.

Example:

[Department] = 'Marketing' and [Department] = 'Support'
like

TRUE if the operand matches a pattern.

Example:

[Department] like '%Marketing%'
in

TRUE if the operand is equal to one of a list of expressions.

Example:

[Department] in ('Marketing', 'Support')

The and operator has more priority than the or.

Comparison Operators

=, <>, <, <=, >, >=

[Total] < 2000

Values

A value is a terminal token representing a concrete element. This can be:

  • user profile property
  • an integer
  • a floating point number
  • a bit
  • a string

Field or user profile property

Use internal name or display name of the user profile property in square brackets

[Title]
[Job Title]
[Department]

Integers

They are represented using numbers.

123456

Floating point numbers

Use the dot to define the decimal part.

123.456 .123

Bit values

Bit values can be either 1 or 0.

1 0

Strings

Any character between single quotes ‘ are evaluated as String. We do not process ” quotes.

'hello'