Use Properties in JQL

To test the saved properties, click on Filters and choose View all Issues. From there, set the search criteria to JQL.

Supported Property Operators

You can use the different types of properties for various comparisons and searches.

String Properties support only the = operator
Text Properties support only the ~ operator
Number Properties support <, =<, >=, >, =, != operators
Date Properties support <, =<, >=, >, =, != operators

The dates follow the format YYYY-MM-DD.

Due to limitations imposed by Atlassian, it's necessary to use predetermined property names. You can observe the property name when defining the values for the properties.

Use Project Properties

To search using the project properties, follow this schema:

CODE

project.<property_name> <operator> <value>

Examples

Give me all the issues from projects located in Switzerland.

CODE

project.jqlStringProperty1 = "CH"

Give me all the issues from projects that the Marketing team is working on.

CODE

project.jqlTextProperty2 ~ "Marketing"

Give me all the issues from projects with a budget higher than 10’000.

CODE

project.jqlNumberProperty1 > 10000

Give me all the issues from projects that need to be finished until 01 Jan 2024.

CODE

project.jqlDateProperty1 =< 2024-01-01

Use User Properties

To search using the project properties, follow this schema:

CODE

reporter.<property_name> <operator> <value>
assignee.<property_name> <operator> <value>

Examples

Give me all the issues that were reported by users from building 2.

CODE

reporter.jqlStringProperty1 = "Building 2"

Give me all the issues where users from the development team work on.

CODE

assignee.jqlTextProperty2 = "Development"

Give me all the issues where new employees work on (have worked on less than 3 projects yet).

CODE

assignee.jqlNumberProperty1 < 3

Give me all the issues where the reporters are away over Christmas.

CODE

reporter.jqlDateProperty1 < 2023-12-17