JQL Search
Smart Checklist supports JQL as an approach for searching checklist items values and checklist progress 🚀
☝️NOTE: To use this functionality, you may refer to either the Checklists or Smart Checklist Progress custom field.
Overview
Smart Checklist data is stored in custom fields and issue properties, making checklist information searchable through JQL.
you can use Smart Checklist's dedicated search functions – simply start typing "Smart Checklist" in the JQL editor to see the list of available functions
alternatively, you can search using the Checklists or Smart Checklist Progress custom fields, or the Smart Checklist issue property.
Search examples
📊 Search by checklist progress
JQL Search option | JQL query |
|---|---|
Issues with opened checklists (not all checklist items completed) |
|
Issues with ALL completed checklists |
|
Issues where there is at least one completed (checked) checklist item |
|
Issues where all checklist items are open (unchecked) |
|
Issues where there is at least one open checklist item |
|
Issues where all checklist items are completed |
|
🗒 Search by checklist items
JQL Search option | JQL query |
|---|---|
Search for checklists containing specific items |
|
Search for an exact phrase in the checklist items or exact checklist items |
|
Search by number of items/headers |
|
☝🏼 Note: Available operators could be used: >, >=, <, <=, =, !=. | |
Search by not empty or empty checklists |
or
|
Search by a specific priority |
|
Search by a specific due date |
|
Search by a specific date mention |
|
☝🏼 Note: Date format used in JQL search should match the date format in the checklist item. | |
Search by checklist items in the particular status |
|
☝🏼 Note: Use default status (Todo, Done, Skipped, and In Progress) or custom statuses. Text is case insensitive, so DONE, Done, or done will return the same results. | |
Search by particular checklist items in the particular status |
|
☝🏼 Note: Search works only for an exact match of the value in To search for the same item in different statuses use OR operator: Text is case sensitive, so only Done, Todo, Skipped, In Progress will return the same results. |
🙋🏽♂️ Search by checklist assignees and user mentions
JQL Search option | JQL query |
|---|---|
Search by assignee |
|
Search by user mention |
|
🚀 JQL combinations for more accurate searches
Operator | JQL Search option | You type |
|---|---|---|
AND | Search for not competed checklists with specific number of items |
|
Search for not competed checklists with a specific date mention |
| |
Search for not completed checklists which contains specific items |
| |
Search for checklists with mentioned current logged user and due date |
| |
Search for checklists with items in the particular status and date mention |
| |
OR | Search for checklists with items in particular statuses |
|
will return checklists that includes items with in progress or todo statuses | ||
Search for checklists with mentions of current logged user and somebody else |
| |
will return checklists that includes mentions of the current logged user or somebody else |
☝🏼 NOTE: If you use combinations of search options (for dates, assignees, and statuses) - search will be done for the whole checklist not for the specific checklists items. If checklist items are found based on the search criteria (one contains the date, another is in needed status, another one has the assignee) - the Issue will be returned in the search results.
NOTE: At this moment, searching for Jira issues where a specific checklist item has completed/ incompleted status is unavailable. 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
Hope everything works for you! 🚀