Skip to:

JQL Functions Collection

works with Jira Server 7.0.0 - 8.20.30 and more

OVERALL RATINGS

We no longer offer sales and support for server apps. You can stay connected by exploring the migration options to either the cloud or Data Center version of this app.

Explore migration program

Key highlights of the appCollection 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")

Supporting media

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.

Resources

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 program

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

Version information

We no longer offer sales and support for server apps. You can still explore the earlier versions but these may not offer the necessary support.

Explore all server versions

Learn and explore

  • What’s Marketplace
  • App installation
  • About Atlassian
  • Atlassian resources
  • Search and ranking
  • Atlassian events
  • Atlassian foundation

Follow