Jira

Using JQL for searching data in Jira

JQL (Jira Query Language) is a very convenient functionality when it comes to advanced searching.

Photo by KOBU Agency on Unsplash

If you are already familiar with SQL, searching in Jira will not be a problem. Jira supports :

  • order by
  • assignee
  • reporter
  • createdDate

For example you want to search for all Done Tasks in the sprint (since the start day of the sprint), here is the query:

issuetype = Task  AND status in (Done) AND updatedDate >= 'yyyy-MM-DD'

Or you want to search for the task that contains attachments:

issuetype = Task  AND attachments is not EMPTY

~~ Hope it helps guys ~~

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store