Basic Queries
Write a query to find all issues assigned to the logged-in user.
assignee = currentUser()
What operator is used to find values within a set?
IN
Find issues updated today.
updated >= startOfDay()
Find issues in project 'DEF' assigned to 'JohnDoe'.
project = "DEF" AND assignee = "JohnDoe"
What's wrong with this query?
project = ABC AND status = 'Done'
Missing quotes around ABC.
Correct query:
project = "ABC" AND status = 'Done'
Find all unresolved issues in project 'ABC'.
project = "ABC" AND resolution = Unresolved
Write a query to find all issues created in the last 7 days.
created >= -7d
Find issues created before January 1, 2023.
created < "2023-01-01"
Show all issues in project 'XYZ' with more than 5 comments.
project = "XYZ" AND commentCount > 5
What's wrong with this query?
assignee IS NOT currentUser()
Incorrect use of IS NOT.
Correct query:
assignee != currentUser()
Query for issues with a priority of 'High' or 'Critical'.
priority IN ("High", "Critical")
Find issues where the description contains 'critical error'.
description ~ "critical error"
Write a query for issues due in the next 30 days.
duedate <= 30d
Find all issues with more than one label.
labels IS NOT EMPTY AND labels != ""
Fix this query:
created >= startOfDay AND updated <= now
Missing parentheses.
Correct query:
created >= startOfDay() AND updated <= now()
Find issues labeled 'bug' that are not assigned.
labels = "bug" AND assignee IS EMPTY
Use a function to find issues resolved at the start of this month.
resolutiondate >= startOfMonth()
Find issues with due dates in the past.
duedate < now()
Query issues created by users in the group 'Developers'.
reporter IN membersOf("Developers")
What's wrong with this query?
priority > 'High'
Priorities cannot be compared with greater/less operators.
Use IN or specific values.
Show all issues where the summary contains the word 'Upgrade'.
summary ~ "Upgrade"
What operator finds fields that do not have a value?
IS EMPTY
Find issues resolved between October 1, 2023, and October 31, 2023.
resolved >= "2023-10-01" AND resolved <= "2023-10-31"
Find all issues with sub-tasks in project 'ABC'.
project = "ABC" AND issuetype = Sub-task
Fix this query:
status ~ 'In Progress'
~ cannot be used with status.
Correct query:
status = "In Progress"