example queries Flashcards

1
Q

find all issues not assigned to “olivier botz”

A

assignee != “olivier botz” OR assignee is empty

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

find all issues reported by me but not assigned to me

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

find all issues that are assigned

A

assignee is not empty

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

A

duedate >= “2021/12/21”

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

find all issues created in the last five days

A

created >= “-5d”

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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

A

updated <= “-30d”

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

find all issues reported by jjack, rrachel or mmatthew

A

reporter in (jjack,rrachel,mmatthew)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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

A

text ~ “opportunity”

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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

A

summary ~ “rooster piglet”

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

A

summary ~ “"juicy fruit”"

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

find all issues resolved by rrachel in 2021

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

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

A

status CHANGED FROM “done” TO “in progress”

How well did you know this?
1
Not at all
2
3
4
5
Perfectly