JQL Search Checklists

Smart Checklist supports JQL as an approach for searching checklist values and checklist progress. Switch to Advanced Search and use the approaches described below.

For Version 5.0.0 and higher

Since version 5.0.0 Smart Checklist for Jira Server and Data Center provides the possibility to examine a more precise JQL search, like search by status or by checklist item, using custom JQL functions.

JQL function

Usage Example

JQL function

Usage Example

allItemsClosed()

Search for issues where ALL checklist items are Closed

"Smart Checklist" = allItemsClosed()

allItemsOpen()

Search for issues where ALL checklist items are Open

"Smart Checklist" = allItemsOpen()

progress(operator,percent)will be deprecated soon

Search for checklists by Progress

"Smart Checklist" = progress(">","15")

Available operators: >, <, >=, <=, =

Use percent value from 0 to 100

ā˜šŸ¼NOTE: Smart Checklist all available operators: >, <, >=, <=, = will be put out of the brackets soon. We will notify you via email about JQL changes but recommend to already use the following syntax:
"Smart Checklist" > progress("80")

progress(percent) new syntax

Ā 

itemStatus(item name, status) using = operator

Search for particular checklist items in a particular status

"Smart Checklist" = itemStatus("PR review completed", "DONE")

Search for particular checklist items in a particular statuses

"Smart Checklist" = itemStatus("PR review completed", "DONE, IN PROGRESS")

Search for checklists that contain particular checklist item

"Smart Checklist" = itemStatus("PR review completed", "*")

itemStatus(item name, status) using ~ operator

Since version 6.1.0 Smart Checklist ā€œ~ā€œ (LIKE operator) could be used for search with this function.

  • Search for checklist items containing search term for the item name in a particular status

"Smart Checklist" ~ itemStatus("requirements", "TO DO") - will find all checklist items containing this search term in status TO DO (It will find e.g. Requirements update, Follow the requirements, test Cases should include verification of requirements specified in this documentation, Security Requirements)

  • Search for checklist items containing search term for the item name in a particular statuses

"Smart Checklist" ~ itemStatus("requirements", "DONE, IN PROGRESS") - will find all checklist items containing this search term in status DONE and IN PROGRESS (It will find e.g. Requirements update, Follow the requirements, test Cases should include verification of requirements specified in this documentation, Security Requirements)

  • Search for checklist items containing search term for the item name in any status

"Smart Checklist" ~ itemStatus("Requirements", "*") - will find all checklist items containing this search term in any status (It will find e.g. Requirements update, Follow the requirements, test Cases should include verification of requirements specified in this documentation, Security Requirements)

  • Search for checklist items could include in item name - simple text, data, assignee

"Smart Checklist" ~ itemStatus("YYYY-MM-DD @username", "DONE") - will find all checklist items containing specified due date and assignee in status DONE

itemAssignee(name)

Search for Assignee(s) mentioned in checklist item

  • example: "Smart Checklist" = itemAssignee("john","john.smith","currentUser()")

Allowed parameters

  • username - as defined in Jira Userā€™s profile, e.g. ā€œjohnā€

  • display name - Full name from Userā€™s profile, e.g ā€œjohn.smithā€

  • currentUser() - currently logged user. You can use it to create a shared filter with aĀ JQL functionĀ that users of your instance could benefit of.

Ā 

itemDate(Date)

Search for fixed Date, indicated in checklist item

  • example "Smart Checklist" = itemDate("2020-01-01")

Allowed formats

  • yyyy-mm-dd

The ā€œitemDateā€ function accepts dates entered in ISO format only

itemDate(RelativeDate)

Search by Relative Date

  • example "Smart Checklist" <= itemDate("0d")

    • read: item has date set (due date) for tomorrow

Allowed parameters: [n]d, [n]w, -[n]d, [-n]w

  • ItemDate("0d") - today

  • ItemDate("1d") - tomorrow

  • ItemDate("-1d") - yesterday

  • ItemDate("1w") - 1 week since now

  • ItemDate("2w 4d") - 2 weeks and 4 days since now

  • ItemDate("-3w 2d") - 3 weeks and 2 days ago

Search for date in between of time range:

"Smart Checklist" >= itemDate("0d") AND "Smart Checklist" < itemDate("2w")

read: search for the checklist item that has date set between today and 2 week ahead

itemStatusDateAssignee(status, date, name) NEW

Search for checklist items with assignee, date and in a particular status

"Smart Checklist" = itemStatusDateAssignee("TO DO", "2024-11-28", "john")- will find all checklist items where john user is mentioned, date 2024-11-28 is set and item status is TO DO

"Smart Checklist" = itemStatusDateAssignee("TO DO", "*", "john smith") - will find all checklist items where john user is mentioned, any or no date is set and item status is TO DO
"Smart Checklist" = itemStatusDateAssignee("TO DO, DONE", "2024-11-28", "*")- will find all checklist items where any or no user is mentioned, date 2024-11-28 is set and item status is TO DO

Allowed parameters

  • assignee - can be username or display name:

    • username - as defined in Jira Userā€™s profile, e.g. ā€œjohnā€

    • display name - Full name from Userā€™s profile, e.g ā€œjohn smithā€

  • status - case-sensitive, for proper search you should use uppercase letters, e.g. TO DO

For versions 4.16.0 and below

To use this functionality you need to set-up "Checklists" custom field, or "Smart Checklist Progress". It depends on what main criteria you'd like to search for.

Smart Checklist supports JQL as an approach for searching checklist items values and checklist progress.

If you set up "Checklists" (multi-line text field) and "Smart Checklist Progress" (single-line text field) which are both custom fields - you can easily apply all JQL search patterns.

Search examples

JQL Search

Usage Examples

JQL Search

Usage Examples

"Smart Checklist Progress" ~ "-Done"

To search for issues with opened checklists (not all checklist items completed).

Ā 

"Smart Checklist Progress" ~ "Done"

To search for issues with ALL completed checklists

"Checklists" is not EMPTY

ToĀ search forĀ all issues that contain checklists on your instance:

Ā 

"Checklists" ~ "your item value"

ToĀ search for checklists containing specific items

Searching for Jira issues where a specific checklist item has completed/ incompleted status is unavailable in versions below the 5.0.0. This happens due to the following limitation:Ā Jira does not index the special character of - and +Ā 

Special characters + - & | ! ( ) { } [ ] ^ ~ * ? \ : Special characters aren't stored in the index, which means you can't search for them. The index only keeps text and numbers, so searching for "\\[Jira Software\\]"Ā andĀ "Jira Software"Ā will have the same effect - escaped special characters ([]) will be ignored in the search.

Source:Ā https://confluence.atlassian.com/jirasoftwareserver0712/search-syntax-for-text-fields-959315338.html