JQL Functions Collection

for Jira Server 7.0.0 - 8.20.22 and more
193 installs
  • Unsupported

As we continue to move towards a cloud future together, new server app sales and installs are no longer available for customers. You can update app version via Atlassian Marketplace until the end of support for server on Feb 15, 2024. Learn more

Collection of JQL functions to create complex queries in Jira using string and date formats

String Formats in an JQL Query

formatString: The equivalent to Java's String.format

More ...

Date formats in an JQL query

formatDate: Allows you to specify a DateFormat that will be applied to the current date. For more information about available date formats take a look at this documentation.

Dynamic String Formats in an JQL Query

String and Date formats combined e.g:

Project = "Test", component has a format Products-Monthname-Year .. e.g. Products-July-2011

project = "Test" AND component = dynamicString("Products-%s-%s", "df:MMMMM","df:yyyy")

More details

The plugin offers the following functions:

  • formatString: The equivalent to Java's String.format
  • formatDate: Allows you to specify a DateFormat that will be applied to the current date. For more information about available date formats take a look at this documentation.
  • dynamicString: Allows a combination of String.format and DateFormats. For more information about available date formats take here, examples can be seen here.
  • If you don't have a clue how to use those JQL functions yet, I strongly advise you to take a look at the examples.

Privacy and security

Privacy policy

Atlassian's privacy policy is not applicable to the use of this app. Please refer to the privacy policy provided by this app's partner.

Partner privacy policy

Security

This app is not part of the Marketplace Bug Bounty program. Learn more

Resources

Gallery

Plugin Installation