Extraction Expressions for Dynamic Groups
The permanent link has been copied.
The dynamic groups automatically update their members based on the specified conditions.
If you select the "Advanced" condition type, you can specify more complicated conditions.
This section describes the operators and the keys that can be used for conditional expressions for extracting members of dynamic groups.
The permanent link has been copied.
You create a conditional expression by combining a key, an operator, and a value for the key.
To create a condition, for example, to extract "the job titles that have Manager01 in their name", the conditional expression looks like below.
Example of conditional expression
title in ("Manager01")
In this case, the "key", the "operator", and the "value for the key" would be as follows:
Key
title
Operator
in
Value for the Key
("Manager01")
The permanent link has been copied.
You can use the following keys.
You can also combine multiple keys. For details, refer to Example of Conditional Expression .
Key
Meaning
user
Login Name
organization
department code
group
Group Code
title
Job Title Code
employeeNumber
Employee ID
birthDate
Birthday
joinDate
Hire Date
The permanent link has been copied.
You can use the following operators.
Operator
Description
=
A = B means A is equal to B.
<
A < B means A is less than B.
<=
A <= B means A is equal to or less than B.
>
A > B means A is greater than B.
>=
A >= B means A is equal to or greater than B.
in
A in B means A is contained in B.
not in
A not in B means A in not contained in B.
The permanent link has been copied.
If you use only one key
Example of condition
Conditional expression
Extract users who belong to a department whose department code is "sales00"
organization in ("sales00")
If you specify multiple key values
Separate key values with commas (,).
Example of condition
Conditional expression
Extract users with job titles whose job title code is "Manager01" or "chief02"
title in ("Manager01", "chief02")
If you concatenate multiple conditions by using "and" and "or" operators
Example of condition
Conditional expression
Extract users who meet all of the following conditions
Belongs to a department whose department code is "sales00" or any other lower department
Has a job title whose job title code is "Manager01"
organization <= "sales00" and title in ("Manager01")
Extract users who meet all of the following conditions
Has a job title whose job title code is "Manager01"
Belongs to a department whose department code is either "Sales00", "Sales01", or "Sales02"
title in ("Manager01") and organization in ("Sales00", "Sales01", "Sales02")
If you combine multiple conditions with specifying priority
Enclose the conditions of higher priority with parenthesis: "()".
Example of condition
Conditional expression
Extract users who meet all of the following conditions
Belongs to a department whose department code is "sales00" or the login name of the user is "sato"
Has a job title whose job title code is "Manager01"
(organization in ("sales00") or user in ("sato")) and title in ("Manager01")
The permanent link has been copied.
A different set of operators is available for each key.
The permanent link has been copied.
Operator
Value for the Key
Extracted User
in
(login name, login name, ...)
Users who match any of the specified login names
not in
(login name, login name, ...)
Users who do not match any of the specified login names
The permanent link has been copied.
Operator
Value for the Key
Extracted User
in
(department code, department code, ..., department code)
Users who belong to any of the specified departments
not in
(department code, department code, ..., department code)
Users who do not belong to any of the specified departments
<
department code
Users who belong to a child of the specified department
<=
department code
Users who belong to the specified department or a child of the specified department
The permanent link has been copied.
Operator
Value for the Key
Extracted User
in
(group code, group code, ..., group code)
Users who belong to any of the specified groups
not in
(group code, group code, ..., group code)
Users who do not belong to any of the specified groups
The permanent link has been copied.
Operator
Value for the Key
Extracted User
in
(job title code, job title code, ..., job title code)
Users who are assigned any of the specified job titles
not in
(job title code, job title code, ..., job title code)
Users who are not assigned any of the specified job titles
=
"no title"
Users who are assigned no job title
The permanent link has been copied.
Operator
Value for the Key
Extracted User
in
(employee ID, employee ID, ..., employee ID)
Users who match any of the specified employee IDs
not in
(employee ID, employee ID, ..., employee ID)
Users who do not match any of the specified employee IDs
The permanent link has been copied.
Note
"birthDate" is only available for data in "yyyy-mm-dd" format.
The time and time zone information will be ignored.
Operator
Value for the Key
Extracted User
=
Birthday
Users whose birthday falls on the specified date
<
Birthday
Users whose birthday is earlier than the specified date
<=
Birthday
Users whose birthday is equal to or earlier than the specified date
>
Birthday
Users whose birthday is later than the specified date
>=
Birthday
Users whose birthday is equal to or later than the specified date
The permanent link has been copied.
Note
"joinDate" is only available for data in "yyyy-mm-dd" format.
The time and time zone information will be ignored.
Operator
Value for the Key
Extracted User
=
Hire Date
Users whose hire date falls on the specified date
<
Hire Date
Users whose hire date is earlier than the specified date
<=
Hire Date
Users whose hire date is equal to or earlier than the specified date
>
Hire Date
Users whose hire date is later than the specified date
>=
Hire Date
Users whose hire date is equal to or later than the specified date