Extraction Expressions for Dynamic Groups

Article Number:020177

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.

Conditional Expression for Dynamic Groups

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")

Available Keys in Conditional Expressions

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

Available Operators in Conditional Expressions

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.

Example of Conditional Expression

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")

Available Operators for Each Key

A different set of operators is available for each key.

For "user" Key

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

For "organization" Key

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

For "group" Key

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

For "title" Key

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

For "employeeNumber" Key

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

For "birthDate" Key

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

For "joinDate" Key

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