Extraction expressions for dynamic groups
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 page provides the details of operators and keys that can be used for conditional expressions for extracting members of dynamic groups.
Conditional expression for dynamic groups
Create a conditional expression by combining a key, an operator, and a value for the key.
Enter the following conditional expression to extract users who have been assigned the job title code of "Manager01".
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")
Available keys in conditional expressions
You can use the following keys.
You can also combine multiple keys.
Combining multiple conditional expressions
| Key | Meaning |
|---|---|
| user | Login name |
| organization | Department code |
| group | Group code |
| title | Job title code |
| employeeNumber | Employee ID |
| birtdDate | Birthday |
| joinDate | Hire date |
Available operators in conditional expressions
You can use the following operators. A different set of operators is available for each key.
- in
- not in
- =
- <
- <=
- >
- >=
For "user" key
The login name to specify for key value should be enclosed with double quotation marks (").
in
Extracts users that match any of the specified login names.
To specify multiple login names, separate them using commas (,).
The following example extracts users whose login names are either "JohnJones", "MichaelWilson", or "MarySmith".
user in ("JohnJones", "MichaelWilson", "MarySmith")not in
Extracts users that do not match any of the specified login names.
To specify multiple login names, separate them using commas (,).
The following example extracts users whose login names do not match "JohnJones", "MichaelWilson", or "MarySmith".
user not in ("JohnJones", "MichaelWilson", "MarySmith")For "organization" key
The organization code to specify for key value should be enclosed with double quotation marks (").
in
Extracts users who belong to any of the specified organizations.
The following example extracts users who belong to organizations whose organization codes are either "Sales01", "Sales02", or "Sales03".
organization in ("Sales01", "Sales02", "Sales03")not in
Extracts users who do not belong to any of the specified organizations.
The following example extracts users who do not belong to organizations whose organization codes are either "Sales01", "Sales02", or "Sales03".
organization not in ("Sales01", "Sales02", "Sales03")<
Extracts users who belong to the child organizations of specified organizations.
The following example extracts users who belong to the child organizations of the organizations whose organization codes are "Sales00".
organization < "Sales00"<=
Extracts users who belong to the specified organizations and their child organizations.
The following example extracts users who belong to the organizations whose organization codes are "Sales00" and also belong to their child organizations.
organization <= "Sales00"For "group" key
The group code to specify for key value should be enclosed with double quotation marks (").
in
Extracts users who belong to any of the specified groups.
The following example extracts users who belong to groups whose group codes are "RecruitmentA", "RecruitmentB", or "RecruitmentC".
group in ("RecruitmentA", "RecruitmentB", "RecruitmentC")not in
Extracts users who do not belong to any of the specified groups.
The following example extracts users who do not belong to groups whose group codes are "RecruitmentA", "RecruitmentB", or "RecruitmentC".
group not in ("RecruitmentA", "RecruitmentB", "RecruitmentC")For "title" key
The job title code to specify for key value should be enclosed with double quotation marks (").
Specifying "no title" extracts users who have no job titles.
in
Extracts users who belong to any of the specified job titles.
The following example extracts users who belong to job titles whose job title codes are "Manager" or "GenManager".
title in ("Manager", "GenManager")not in
Extracts users who do not belong to any of the specified job titles.
The following example extracts users who do not belong to job titles whose job title codes are "Manager" or "GenManager".
title not in ("Manager", "GenManager")For "employeeNumber" key
in
Extracts users that match any of the specified employee IDs.
The following example extracts users whose employee IDs are "0001" or "0002".
employeeNumber in ("0001", "0002")not in
Extracts users that do not match any of the specified employee IDs.
The following example extracts users whose employee IDs are not "0001" or "0002".
employeeNumber not in ("0001", "0002")For "birthDate" key
The date to specify for key value should be enclosed with double quotation marks (") and specified using "yyyy-mm-dd" format.
The time and time zone information will be ignored.
=
Extracts users whose birthday matches the specified date.
The following example extracts users whose birthday is August 8, 1997.
birthDate = "1997-08-08"<
Extracts users whose birthday is earlier than the specified date.
The following example extracts users whose birthday is earlier than August 8, 1997.
birthDate < "1997-08-08"<=
Extracts users whose birthday is equal to or earlier than the specified date.
The following example extracts users whose birthday is equal to or earlier than August 8, 1997.
birthDate <= "1997-08-08">
Extracts users whose birthday is later than the specified date.
The following example extracts users whose birthday is later than August 8, 1997.
birthDate > "1997-08-08">=
Extracts users whose birthday is equal to or later than the specified date.
The following example extracts users whose birthday is equal to or later than August 8, 1997.
birthDate >= "1997-08-08"For "joinDate" key
The date to specify for key value should be enclosed with double quotation marks (") and specified using "yyyy-mm-dd" format.
The time and time zone information will be ignored.
=
Extracts users whose hire date matches the specified date.
The following example extracts users whose hire date is May 1, 2017.
joinDate = "2017-05-01"<
Extracts users whose hire date is earlier than the specified date.
The following example extracts users whose hire date is earlier than May 1, 2017.
joinDate < "2017-05-01"<=
Extracts users whose hire date is equal to or earlier than the specified date.
The following example extracts users whose hire date is equal to or earlier than May 1, 2017.
joinDate <= "2017-05-01">
Extracts users whose hire date is later than the specified date.
The following example extracts users whose hire date is later than May 1, 2017.
joinDate > "2017-05-01">=
Extracts users whose hire date is equal to or later than the specified date.
The following example extracts users whose hire date is equal to or later than May 1, 2017.
joinDate >= "2017-05-01"Combining multiple conditional expressions
To extract users who satisfy all conditional expressions
Concatenate conditional expressions using "and" operator.
The following example shows a conditional expression that extracts users who satisfy all conditions below.
- Belongs to a department whose department code is "sales00" or any other lower department.
- Has a job title whose job title code is "Manager01".
Conditional expression
organization <= "sales00" and title in ("Manager01")To extract users who satisfy one of the conditional expressions
Concatenate conditional expressions using "or" operator.
The following example shows a conditional expression that extracts users who satisfy one of the following conditions.
- Has a job title whose job title code is "Manager01".
- Belongs to one of the groups whose group code is either "Leader00" or "Leader01".
Conditional expression
title in ("Manager01") or group in ("Leader00", "Leader01", "Leader02")To combine conditional expressions with specifying priority
Enclose the conditions of higher priority with parenthesis: "()".
The following example shows a conditional expression that extracts users who satisfy all conditions below.
- Belongs to an organization whose organization code is "Sales00", or the login name is "manami-tanaka".
- Has a job title whose job title code is "Manager01".
Conditional expression
(organization in ("Sales00") or user in ("manami-tanaka")) and title in ("Manager01")