Jra Query Language (JQL) - Yash-777/MyWorld GitHub Wiki
The advanced search is the most powerful and flexible way to search for your issues in Jira. You can use the Jira Query Language (JQL) to specify criteria that cannot be defined in the quick or basic searches. For example, you can use the ORDER BY clause in a JQL query to search for issues and display them in an ascending or descending order.
JQL is for everyone: developers, testers, agile project managers, and business users. However, you need to know how to construct structured queries using JQL to use this feature.
🧩 Generic Formula chatgpt.com
project = <PROJECT_KEY>
AND created >= startOfMonth(-N)
AND created < startOfMonth(-(N-1))
ORDER BY created ASC
🔎 Explanation
-
-N= how many months back from current month you want to start. -
-(N-1)= the next month’s start (so it excludes issues after that).
📌 Current Month → September (9)
We want to look back to May (month 5). startOfMonth("-N") goes back N months from the current month.
- April (Month 4)
project = MyProj AND created >= startOfMonth("-5") AND created < startOfMonth("-4") ORDER BY created ASC