Automation rule - create issue if issue with the same summary doesn't exist

[Ana MINCA]

Hello,

I have the following process that I would like to cover via an automation rule:

• Every day the team needs to do some checks in production (each time the same ones)
• In order to make sure they do not forget this step and we also have stats regarding the checks I would like to create an automation rule that each day, at the same time automatically creates a ticket in their Kanban board that contains the exact same information

Until here I have no issues, I managed to create the rule and the rule is triggered everyday at the specified time with the exact same template.

• As an additional layer, I want to check if the created ticket from the day before is in any other status then "Done", and if it is I want to not create the one scheduled for the current day (ex: If today is Tuesday and I still have in progress the ticket from Monday the rule should not create a new one)

Do you have any suggestions about how I can achieve this?

Thank you !

[Gareth Cantrell · Accepted solution]

@Ana MINCA 

You can insert a JQL Condition immediately before the Create new story action, and use a query similar to the following:

type = Story AND summary ~ "Summary of created issue" AND resolution = Unresolved

[Ana MINCA]

Thank you for the answer. :) It works ! 

[Alex Koxaras _Relational_]

Hi @Ana MINCA

I would insert a JQL check prior of the action for creating the issue, just like the following image (don't mind the "Manual" trigger):

The JQL statement is this:

summary ~ "My Summary" AND status != Done AND (created >= startofday(-1) AND created < endofday(-1))

I would change the "My Summary" wording with the summary you give when creating the ticket.

Let me know if that worked.
Alex