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:
project.<property_name> <operator> <value>
Examples
Give me all the issues from projects located in Switzerland.
project.jqlStringProperty1 = "CH"
Give me all the issues from projects that the Marketing team is working on.
project.jqlTextProperty2 ~ "Marketing"
Give me all the issues from projects with a budget higher than 10’000.
project.jqlNumberProperty1 > 10000
Give me all the issues from projects that need to be finished until .
project.jqlDateProperty1 =< 2024-01-01
Use User Properties
To search using the project properties, follow this schema:
reporter.<property_name> <operator> <value>
assignee.<property_name> <operator> <value>
Examples
Give me all the issues that were reported by users from building 2.
reporter.jqlStringProperty1 = "Building 2"
Give me all the issues where users from the development team work on.
assignee.jqlTextProperty2 = "Development"
Give me all the issues where new employees work on (have worked on less than 3 projects yet).
assignee.jqlNumberProperty1 < 3
Give me all the issues where the reporters are away over Christmas.
reporter.jqlDateProperty1 < 2023-12-17