Examples

Dynamic Queries

The first parameter for the JQL function dynamicString is the string's format. Use placeholders as you are used from Java's String.format method.

The following parameters are inserted into the first format string - there is no limit.

You are able to create a special date format if you prefix on of the parameters with a df: string.

Examples

  • Query for issues from a project named "Test Project" and with a component in format like Products-Monthname-Year .. e.g. Products-July-2011

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

  • Query for issues from a project named "Test Project" and fixed version in a format like CW-CALENDARWEEK .. e.g. CW-28

    The JQL query: project = "Test Project" AND fixVersion = dynamicString("CW-%s", "df:w")