JQL – JIRA Query Language

status = "To Do" OR status = "In Progress"

 

status IN ("To Do", "In Progress")
status NOT IN ("To Do", "In Progress")
project = DEMO
AND resolution NOT IN (Fixed, "Won't Fix")

statusCategory = "To Do"

statusCategory NOT IN ("To Do", "In Progress")

statusCategory != "Done"

statusCategory NOT IN (Done, "In Progress")
AND assignee = currentUser()

statusCategory NOT IN (Done, "In Progress")
AND assignee IN membersOf("jira-administrators")

statusCategory NOT IN (Done, "In Progress")
AND assignee = currentUser()
ORDER BY priority DESC, key ASC

project = DEMO
AND status WAS Done
AND status != Done

project = DEMO
AND status WAS Done
AND status != Done
AND updated > -1d

Sprint IN closedSprints()

Sprint IN openSprints()

Sprint IN futureSprints()

project = DEMO
AND sprint in openSprints()
AND status != Done
AND updated > -1d

Flagged IS NOT EMPTY

project = DEMO
AND sprint IN openSprints()
AND (statusCategory = "In Progress" OR Flagged is not EMPTY)

 

AND updated >= -1d
project = DEMO
AND sprint IN openSprints()
AND assignee = currentUser()

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

project = DEMO
AND updated >= -7d
AND assignee IN membersOf("jira-administrators")
due >= 2017-03-01 AND due <= 2017-03-31 due >= startOfMonth() AND due <= endOfMonth() updated >= startOfWeek(-7d) AND updated <= endOfWeek(-7d)
due <= now()
AND statusCategory != Done

status WAS NOT "In Progress" BEFORE "2011/02/02"
status WAS NOT IN ("Resolved","In Progress") BEFORE "2011/02/02"
status WAS IN ("Resolved","In Progress")
status WAS "Resolved" BY jsmith DURING ("2010/01/01","2011/01/01")
status WAS "Resolved" BY jsmith BEFORE "2011/02/02"
AFTER "date"
BEFORE "date"
BY "username"
DURING ("date1","date2")
ON "date"
FROM "oldvalue"
TO "newvalue"

assignee CHANGED

priority CHANGED BY freddo BEFORE endOfWeek() AFTER startOfWeek()

 

status CHANGED FROM "In Progress" TO "Open"
currentLogin()
lastLogin()
now()
startOfDay()
startOfWeek()
startOfMonth()
startOfYear()
endOfDay()
endOfWeek()
endOfMonth()
endOfYear()