assignee is not EMPTY AND created >= -90d
assignee is not EMPTY AND created >= startOfMonth(-3) AND created <= endOfMonth(-1)
Calculate the Start Date of Last Quarter:
Determine the current month and calculate the start of the quarter.
For example, if the current month is April, the start of the last quarter would be January 1st.
Use JQL to Filter by Date Range:
Assuming the current month is June, the last quarter would include April, May, and June. Here’s how you construct the JQL query for issues created in the last quarter:
jql
Copy code
assignee is not EMPTY AND created >= startOfMonth(-3) AND created <= endOfMonth(-1)
startOfMonth(-3): This function calculates the start of the month three months ago. In this example, it corresponds to April 1st.
endOfMonth(-1): This function calculates the end of the previous month. In this case, it represents the end of June.
Explanation of the Query Components:
assignee is not EMPTY: Ensures that the issue has an assignee assigned.
created >= startOfMonth(-3): Matches issues created on or after the start of the third month ago (beginning of last quarter).
created <= endOfMonth(-1): Matches issues created on or before the end of the previous month (end of last quarter).
Adjustments Based on Current Month:
If you are executing this query in a different month, adjust the startOfMonth() and endOfMonth() offsets accordingly to match the correct date range for the last quarter relative to the current date.
Usage in Jira:
Log in to Jira and navigate to Issues > Search for issues.
Click on Advanced to switch to Advanced Search mode.
Enter the JQL query assignee is not EMPTY AND created >= startOfMonth(-3) AND created <= endOfMonth(-1).
Run the query to view issues that match the criteria for the last quarter.
Conclusion:
By using JQL functions startOfMonth() and endOfMonth() with appropriate offsets, you can effectively filter issues created within the last quarter where the assignee is not empty. This approach allows you to precisely define and retrieve the data you need directly within Jira's search functionality.