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 ~~