example queries Flashcards
find all issues not assigned to “olivier botz”
assignee != “olivier botz” OR assignee is empty
find all issues reported by me but not assigned to me
reporter = currentUser() AND assignee != currentUser()
find all issues that are assigned
assignee is not empty
find all issues due on or after 21/12/2021
duedate >= “2021/12/21”
find all issues created in the last five days
created >= “-5d”
find all issues that have not been updated in the last 30 days
updated <= “-30d”
find all issues reported by jjack, rrachel or mmatthew
reporter in (jjack,rrachel,mmatthew)
find all issues not assigned to jjack or rrachel (including unassigned)
assignee not in (jjack, rrachel) OR assignee is empty
find all issues where Summary, Description, Environment or Comments contain “opportunity”
text ~ “opportunity”
find all issues where the summary contains the words “rooster” and the word “piglet”
summary ~ “rooster piglet”
find all issues where the description contains the exact phrase “juicy fruit”
summary ~ “"juicy fruit”"
find all issues resolved by jjack before 18/02/2021
status WAS “resolved” BY jjack BEFORE “2021/02/18”
find all issues resolved by rrachel in 2021
status WAS “resolved” by rrachel DURING(“2021/01/01”,”2022/01/01” )
find all issues that have never been in status ‘resolved’ or ‘in progress’
status WAS NOT IN (“resolved”, “in progress”)
find issues whose status has changed from “done” back to “in progress”
status CHANGED FROM “done” TO “in progress”