2
260
Customers have installed this app in at least 260 active instances.

    JQL Functions Collection

    by Micha Kops (hasCode.com)for Jira Server 7.0.0 - 8.13.3 and more versions
    Versions available for Jira Server 4.3 - 6.4.14
    Unsupported
    This app isn't formally supported.

    See existing Q&A in Atlassian CommunityAsk a question in the Atlassian Community

    Unsupported
    This app isn't formally supported.

    See existing Q&A in Atlassian CommunityAsk a question in the Atlassian Community

    Unsupported
    This app isn't formally supported.

    See existing Q&A in Atlassian CommunityAsk a question in the Atlassian Community

    Get it nowFree app

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

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

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

    String Formats in an JQL Query

    Date formats in an JQL query

    Dynamic String Formats in an JQL Query

    formatString: The equivalent to Java's String.format

    More ...

    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.

    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.

    Reviews for cloud

    (2)
    Sign in to write a review
    by cackle ru on 2015-03-30
    0 out of 3 found this review helpful
    Was this review helpful?YesNo

    Reviews for server

    (2)
    Sign in to write a review
    by Pavels Avens on 2017-12-21
    Very useful!
    Was this review helpful?YesNo
    Micha Kops (hasCode.com)

    Hi Pavels,

    thanks for your kind feedback!

    Cheers,

    Micha

    by cackle ru on 2015-03-30
    0 out of 3 found this review helpful
    Was this review helpful?YesNo

    Reviews for Data Center

    (2)
    Sign in to write a review
    by cackle ru on 2015-03-30
    0 out of 3 found this review helpful
    Was this review helpful?YesNo

    Cloud Pricing

    Server Pricing

    Data Center Pricing

    Basic support resources are available for this app.

    Vendor support resources

    Documentation

    Find out how this app works.

    See existing Q&A in Atlassian CommunityAsk a question in the Atlassian Community

    Atlassian-hosted discussions connect you to other customers who use this app.

    Versions

    Version 1.6.0 • Jira Server 7.0.0 - 8.13.3 • Released 2020-04-04

    Summary

    Jira 8.8 / Documentation

    Installation

    1. Log into your Jira instance as an admin.
    2. Click the admin dropdown and choose Add-ons. The Manage add-ons screen loads.
    3. Click Find new apps or Find new add-ons from the left-hand side of the page.
    4. Locate JQL Functions Collection via search. Results include app versions compatible with your Jira instance.
    5. Click Install to download and install your app.
    6. You're all set! Click Close in the Installed and ready to go dialog.

    To find older JQL Functions Collection versions compatible with your instance, you can look through our version history page.

    Similar apps