example queries

Question 1

find all issues not assigned to “olivier botz”

Answer 1

assignee != “olivier botz” OR assignee is empty

Question 2

find all issues reported by me but not assigned to me

Answer 2

reporter = currentUser() AND assignee != currentUser()

Question 3

find all issues that are assigned

Answer 3

assignee is not empty

Question 4

find all issues due on or after 21/12/2021

Answer 4

duedate >= “2021/12/21”

Question 5

find all issues created in the last five days

Answer 5

created >= “-5d”

Question 6

find all issues that have not been updated in the last 30 days

Answer 6

updated <= “-30d”

Question 7

find all issues reported by jjack, rrachel or mmatthew

Answer 7

reporter in (jjack,rrachel,mmatthew)

Question 8

find all issues not assigned to jjack or rrachel (including unassigned)

Answer 8

assignee not in (jjack, rrachel) OR assignee is empty

Question 9

find all issues where Summary, Description, Environment or Comments contain “opportunity”

Answer 9

text ~ “opportunity”

Question 10

find all issues where the summary contains the words “rooster” and the word “piglet”

Answer 10

summary ~ “rooster piglet”

Question 11

find all issues where the description contains the exact phrase “juicy fruit”

Answer 11

summary ~ “"juicy fruit”"

Question 12

find all issues resolved by jjack before 18/02/2021

Answer 12

status WAS “resolved” BY jjack BEFORE “2021/02/18”

Question 13

find all issues resolved by rrachel in 2021

Answer 13

status WAS “resolved” by rrachel DURING(“2021/01/01”,”2022/01/01” )

Question 14

find all issues that have never been in status ‘resolved’ or ‘in progress’

Answer 14

status WAS NOT IN (“resolved”, “in progress”)

Question 15

find issues whose status has changed from “done” back to “in progress”

Answer 15

status CHANGED FROM “done” TO “in progress”