Filter out issues that were deployed last year

[Priyanka Gupta]

Hello,

I am creating some dashboards for the business and starting with an Issues report that the dashboard will pull the data from. In that Issues report, I want to filter out issues of which the status was moved to "Deployed" last year. Can anyone help me with this?

Thank you,

Pri

[Bill Sheboy]

Hi @Priyanka Gupta -- Welcome to the Atlassian Community!

Please try using the CHANGED operator with your JQL: https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-operators/#Advancedsearchingoperatorsreference-CHANGEDCHANGED

For example,

project = myProjectName
 AND NOT status CHANGED TO Deployed DURING (startOfYear(-1), endOfYear(-1))
 AND status = Deployed

Please note this would include things deployed before last year and during this year, so adjust this to meet your needs.

Kind regards,
Bill

[G subramanyam]

Hi @Priyanka Gupta welcome to the Atlassian community.

You may try out this filter:  status = deployed AND createdDate >= 2022-01-01 AND createdDate < 2023-01-01 AND priority = high

[Priyanka Gupta]

Hi G! Thank you for your response. The filter above will create a report of all issues "Deployed" last year instead of a report that excludes all issues "Deployed" last year correct? If so, I am looking for the latter - report that excludes. 

[G subramanyam]

That query will filter out issues that were moved to the "Deployed" status last year and that have a certain priority.

[Kelly Arrey]

@G subramanyam Your filter returns High Priority issues currently in Deployed Status which were created last year. Please see Bill's suggestion above which takes into account when the issues were transitioned to Deployed Status.