Need help with JIRA automation

[Mayank Rawat]

I have a JIRA filter and I would like to open all the JIRA tickets automatically without doing it manually present under the filter daily at certain time.

This is what my approach is:

Added a Trigger:

• Chose Scheduled Trigger.
• Set it to run daily at 9 AM IST to end date - 'Never ends'.
• Under “Run a JQL query”, entered my filter JQL.

After this I am trying to add appropriate action to open all the child tickets under the JQL but not able to figure out the right action.

Can someone help me with this.

[Pallavi Shirodkar]

Hi @Mayank Rawat 

Can you please try this once

Trigger that is scheduled: Choose "Scheduled" and choose a frequency of 9 AM IST every day.

Action for lookup issues: Enter your filter in "Lookup Issues" as a JQL.

Branch rule and associated problems (JQL): To make the rule iterate through every ticket in the lookup, add a branch for JQL and use the same filter JQL.

Action on the transition issue (inside the branch): Choose the "Transition issue" action and set the status to "Open" (or the corresponding workflow value).

Hope this helps.

[Mayank Rawat]

I am trying this. I will let you know if it works.

[Pallavi Shirodkar]

is it working?

[Valerie Knapp]

Hi @Mayank Rawat , welcome to the Atlassian Community and thanks for your post.

Can we back up a step please, you want to create, every day, a series of tickets under a parent?

Can I ask why please?

The JQL for this should be relatively simple, in that case, you should be able to write, Parent in (key-1). I always recommend people to use the Automation library to find an example rule and modify that, like these - https://www.atlassian.com/software/jira/automation-template-library/rules#/rule-list?systemLabelId=all&filterText=sub&page=1&pageSize=20&sortKey=name&sortOrder=ASC 

Please have a look at these and share your feedback.

Best wishes

[Mayank Rawat]

Hi,  I am not creating daily new tickets under a parent. I am trying to open the tickets daily under the JIRA filter query so that my SLA is counted accurately for the reporting that team has created. 

Currently unless we open the JIRA ticket, SLA still counts the SLA days open as a day when it was opened last.

I am trying to find a way if these JIRA tickets can be opened automatically daily so that our reporting is accurate which team opening them manually.