Versions Compared

Old Version 14

changes.mady.by.user Pavel Pavlovsky

Saved on

compared with

New Version 15

changes.mady.by.user Olena Brazhko

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

allItemsClosed()

Search for issues where ALL checklist items are Closed

“Smart

"Smart Checklist" = allItemsClosed()

allItemsOpen()

Search for issues where ALL checklist items are Open

“Smart

"Smart Checklist" = allItemsOpen()

progress(operator,percent)

Search for checklists by Progress

“Smart

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

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

Use percent value from 0 to 100

itemStatus(item name, status)

Search for particular checklist items in a particular status

“Smart

"Smart Checklist" = itemStatus(

”PR

"PR review

completed”

completed",

”DONE

"DONE")

Search for particular checklist items in a particular statuses

“Smart

"Smart Checklist" = itemStatus(

”PR

"PR review

completed”

completed",

”DONE

"DONE, IN

PROGRESS”

PROGRESS")

Search for checklists that contain particular checklist item

“Smart

"Smart Checklist" = itemStatus(

”PR

"PR review

completed”

completed",

”

"*

”

")

itemAssignee(name)

Search for Assignee(s) mentioned in checklist item

  • example:

“Smart Checklist”

  • "Smart Checklist" = itemAssignee(

“john“

  • "john","john.smith","@john")

Allowed parameters

  • username - as defined in Jira User’s profile, e.g. “john”

  • display name - Full name from User’s profike, e.g “john.smith”

  • mention - any string in checklist item that has “@” as prefix, like: @john

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

Image Removed
Image Added

itemDate(Date)

Search for fixed Date, indicated in checklist item

  • example

“Smart Checklist”

  • "Smart Checklist" = itemDate(

“2020

  • "2020-01-

01“

  • 01")

Allowed formats

  • yyyy-mm-dd

Note

The “itemDate” function accepts dates entered in ISO format only

itemDate(RelativeDate)

Search by Relative Date

  • example

“Smart Checklist”

  • "Smart Checklist" <= itemDate(

“0d

  • "0d")

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

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

  • ItemDate(

“0d”

  • "0d") - today

  • ItemDate(

“1d”

  • "1d") - tomorrow

  • ItemDate(

“

  • "-

1d”

  • 1d") - yesterday

  • ItemDate(

“1w”

  • "1w") - 1 week since now

  • ItemDate(

“2w 4d”

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

  • ItemDate(

“

  • "-3w

2d”

  • 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: shearch for the checklist item that has date set between today and 2 week ahead

For versions 4.16.0 and below

...

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

"Smart Checklist Progress" ~ "-Done"

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

Image Modified

"Smart Checklist Progress" ~ "Done"

To search for issues with ALL completed checklists

Image Modified

"Checklists" is not EMPTY

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

Image Modified

“Checklists” ~ “your item value“

"Checklists" ~ "your item value"

To search for checklists containing specific items

Note

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

...