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'