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.
These operators can do some logical comparison between other expressions:
TRUE if either Boolean expression is TRUE.
[Department] = 'Marketing' or [Department] = 'Support'
TRUE if both Boolean expressions are TRUE.
[Department] = 'Marketing' and [Department] = 'Support'
TRUE if the operand matches a pattern.
[Department] like '%Marketing%'
TRUE if the operand is equal to one of a list of expressions.
[Department] in ('Marketing', 'Support')
The and operator has more priority than the or.
=, <>, <, <=, >, >=
[Total] < 2000
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]
They are represented using numbers.
Floating point numbers
Use the dot to define the decimal part.
Bit values can be either 1 or 0.
Any character between single quotes ‘ are evaluated as String. We do not process ” quotes.