How can I search for issues with the QA Root Cause or Automation status changed to some values?

[Diana Paraschiv]

Hi,

I want to search for all the issues for which the QA Root Cause or the Automation Status changed to some specific values, in a certain timeframe? For example, all the issues for which the Automation Status was set as Automation Candidate during June.

Thanks!

[Yuliia_Borivets__SaaSJet_]

Hi @Diana Paraschiv 

Have you tried JQL search? I'm not sure, but something like this may work:

status WAS Automation Candidate DURING ("2022/06/01","2022/07/01")

Another solution you can try is Issue History for Jira (an app developed by my team). Here you can filter by June or any other custom dates. You will see all issue changes, including statuses (just add the status field to the grid's column).

It looks like this:

Let me know if you have any questions.

[Trudy Claspill]

Hello @Diana Paraschiv 

Welcome to the community.

Jira provides only very limited capabilities to search for issues based on their history, and those are limited to certain system fields. You will need to use a third party app or build something yourself using the API.

For the future, if you don't want to use an app, then you could define custom Date fields and set those fields when those items are changed. They you would be able to do a search based on those date fields.

[Diana Paraschiv]

Thank you for your feedback. Could you, please, detail more the second point regarding Custom date field? How should I do this?

[Trudy Claspill]

Are you working with Jira Cloud or Jira Server/Data Center?

If Jira Cloud, are you working with a Company Managed project or Team Managed project?

If you are working with Jira Server/Data Center, or Jira Cloud and a Company Managed project, then you would need to work with a Jira Administrator for your instance to have additional custom fields created and added to your project so that it would be possible to record the dates of change for the QA Root Cause and Automation fields.

If you are working with Jira Cloud and Team Managed projects, then the Project Administrator has the ability to add custom fields to the project.

To actually record those dates would require the use of automation features. If you are using Jira Cloud there is a built in Automation feature that could be used to set those custom date fields when the QA Root Cause or Automation fields change. That feature is accessible to Project Admins unless the Jira Admins have disabled it.

If you are working with Jira Server/Data Center, then the Automation for Jira feature is something you have to add to your system. There are other alternative apps that can be used to help with automatically setting field values. If you are in this environment and happen to be working with a Service Desk/Management type of project, those project types do have some Automation rule management features built in. It really depends on your environment. If you