JQL Search
Smart Checklist supports JQL as an approach for searching checklist items values and checklist progress π
To use this functionality you may need to set up "Checklists" or "Smart Checklist Progress" custom field. It depends on what main criteria you'd like to search for.
Β
Contents ππ»
Β
Guide to set up custom fields:
π’ Company-managed projects:
π₯ Next-gen projects:
βπΌ NOTE: If you are using the next-gen project, make sure that the added custom fields has a global context. To add global context to your custom fields, follow the official Atlassian guide.
Β
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 | You type |
---|---|
Search for checklists containing specific items |
|
Search for an exact phrase in the checklist items or exact checklist items |
|
Search by number of items |
|
βπΌ Note: Available operators could be used: >, >=, <, <=, =, !=. | |
Search by not empty or empty checklists cHECKLISts FIElD required |
or
|
Search by a specified due date or related dates |
|
βπΌ Note: | |
Search by checklist items in the particular status |
|
βπΌ Note: Use default status (Todo, Done, Skipped, and In Progress) or custom statuses. | |
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: |
Β
ππ½ββοΈ Search by checklist assignees:
JQL Search option | You type |
---|---|
Search by currently logged user |
|
Search by any user |
|
βπΌ Note: donβt use β@β symbol | |
Search by custom 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 due date |
| |
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 due date |
| |
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 |
Β
Β
Hope everything works for you! π