Extraction Expressions for Dynamic Groups

Article Number:020177
Intended audience: Kintone Users & System Administrators

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

The content has been copied.
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".

The content has been copied.
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".

The content has been copied.
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".

The content has been copied.
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".

The content has been copied.
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".

The content has been copied.
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.

The content has been copied.
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".

The content has been copied.
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".

The content has been copied.
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 (").

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

The content has been copied.
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".

The content has been copied.
title not in ("Manager", "GenManager")
=

You can extract users whose job titles are not configured.

The content has been copied.
title = "no title"

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

The content has been copied.
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".

The content has been copied.
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

The content has been copied.
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

The content has been copied.
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

The content has been copied.
(organization in ("Sales00") or user in ("manami-tanaka")) and title in ("Manager01")