Jira JQL: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
Line 22: Line 22:


  status = Closed AND assignee = currentUser() ORDER BY updated DESC
  status = Closed AND assignee = currentUser() ORDER BY updated DESC
updated > startOfDay(-1d) AND timeSpent > 0 AND assignee = ofeodorov ORDER BY updatedDate ASC
project = FDIS AND assignee = currentUser() AND resolution = Unresolved AND sprint = "Sprint 8, 1/4" ORDER BY updated DESC

Revision as of 17:25, 8 August 2019

Internal

Overview

Functions

Functions Reference

Time Functions

Also see Time Format.

startOfDay()

endOfDay()

startOfWeek()

startOfMonth()

startOfYear()

Examples

status = Closed AND assignee = currentUser() ORDER BY updated DESC
updated > startOfDay(-1d) AND timeSpent > 0 AND assignee = ofeodorov ORDER BY updatedDate ASC
project = FDIS AND assignee = currentUser() AND resolution = Unresolved AND sprint = "Sprint 8, 1/4" ORDER BY updated DESC