Automated Search Queries in JIRA Cloud

Raul Cesar de Leon

Hi everyone, 

I have the basics in searching for queries that updated from status X to status Y for a specific time period. 

project = [project name] AND status changed FROM "[Status X]" TO "[Status Y]" DURING ('YYYY/MM/DD X]', 'YYYY/MM/DD Y]')

With a few tweaks to the query, I can also trace which tickets were created for the same time period. 

I can automate JIRA to automatically update a field if an issue transitions from one status to another but I cannot schedule JIRA to automatically update its search string so that I can pull up data for the week every Friday. 

I want to automate the pulling up of data every week on Fridays without copy/pasting the search queries and modifying the date ranges. I checked the automation documentation and it has more to do with the issues raised in jira rather than the act of searching the jira project for specific issues.

Searching the documentation available and training videos in YouTube/Atlassian University don't seem to get me the results I need. 

Can this be done without jira plugins? If plugins are required, what plugins are recommended?

Thanks in adv. 

 

 

Liam Green

Hi @Raul Cesar de Leon 

Welcome to the Community!

I think it would be possible with operators such as 'StartofWeek' or 'StartofMonth'

Using your JQL, I've amended it to show tickets changed during last week

project = [project name] AND status changed FROM "[Status X]" TO "[Status Y]" DURING (StartofWeek(-1), EndofWeek(-1))

Worth noting that the end of the week is Saturday - so if you have a lot of tickets logged over weekends then you might want to amend.

Using 'Startof' or  'Endof' means it moves with the current date / time.

Hope that helps,

Regards, Liam