2.5JQL Functions

JQL includes built-in functions that make queries dynamic and reusable.

Function	What It Does	Example
currentUser()	Your Jira username	assignee = currentUser()
now()	Current date/time	created > now("-7d")
startOfDay()	Start of today	created >= startOfDay()
startOfWeek()	Start of this week	created >= startOfWeek()
startOfMonth()	Start of this month	created >= startOfMonth()
startOfSprint()	Start of the current sprint	created >= startOfSprint()
endOfSprint()	End of the current sprint	due <= endOfSprint()
openSprints()	Currently active sprints	sprint in openSprints()
closedSprints()	Completed sprints	sprint in closedSprints()
membersOf("group")	All users in a group	assignee in membersOf("qa-team")

Relative Date Syntax

-- Last 7 days
created >= -7d

-- Last 2 weeks
created >= -2w

-- Since specific date
created >= "2024-01-15"

-- Between dates
created >= "2024-01-01" AND created <= "2024-01-31"

-- This quarter
created >= startOfMonth(-2) AND created <= endOfMonth()