Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Automation to check mailconnector

Some times our mailconnector fails. Therefore I tried to make two automation rules:

The first rule sends an email to the connector, with summary 'mailconnector check', this works.

The second rule must lookup if a ticket is created with the summary 'mailconnector check', if yes, the ticket must be deleted, if not then an email must be send to the admin.

How can I made a rule who is looking up for these specific ticket and if found it must be deleted.

 

2 answers

1 accepted

0 votes
Answer accepted

Hi Bill, see below the details.

image.png

image.png

image.png

image.png

I have one ticket with the right description:

image.png

image.png

 

In this situation there won't be send an mail in my opinion.

After I deleted this ticket, the log file is:

image.png

Also in this situation a mail has been send. I don't understand what happens.

Regards.

Hi @Evert Morren 

That is an interesting use case to check for availability.  Well done!

To find your issue to delete, consider how to make it unique-enough to find while being different from people-created issues.

For example, perhaps put something in the summary you can test with a condition, such as "mail connector TEST issue".

Kind regards,
Bill

Hi Bill, true, the summary must unique, but how can I search through the issue to find this specific issue?

How many of these "canary" issues do you expect to exist at one time?  If only one then:

  • trigger: issue created
  • condition: summary = "mail connector TEST issue"
  • action: delete issue

I recommend using a longer and more unique summary to reduce the risks of problems.

If you expect there to be multiple, and you want to remove them at one time, consider instead using a scheduled trigger rule with the JQL to find them:

project = myProjectName AND summary = "mail connector TEST issue"

Hi Bill, 

The trigger "issue created" doesn't work, if the mail connector doesn't work there is no issue. The trigger must be sheduled. I made a sheduled rule but get the error message:

image.png

It seems not possible to trigger a scheduled rule without a JQL statement? 

Hi Evert,

Nope, you definitely can have a scheduled trigger rule without JQL.

And, are you using the Cloud or Server/Data Center version, as each has different batch processing options?  For example for Cloud:

  • trigger: scheduled on the cycle you select
  • action: Lookup Issues with JQL replacing your project name and any other criteria
project = myProject 
AND summary = "mail connector TEST issue"
AND ...any other criteria
  • if/else condition: advanced compare condition: test for found issues with
    • first value: {{lookupIssues.size|0}}
    • condition: greater than
    • second value: 0
      • action: delete issue
  • else
    • action: send the email

 

This works for one-issue-found.  If you possibly have more to delete, you will need a branch with the JQL before the delete action.

Hi Bill, Thank you for reply.

I have made the rule you suggested, but still the same error.

image.png

It seems, it is not possible to do actions on an issue, without the option to run JQL?

I try it with two rules, the first one send a mail if these is no issue (mailconnector doesn't work), the second deletes the ticket if there is a ticket (mailconnector works). The first one doesn't work, what do I wrong?

image.png

Can you help me?

Would you please post images of:

  • the details of your Scheduled trigger, and
  • of the audit log for a run where it does not work as you expect?

Thanks!

Hi Bill, see below the details.

image.png

image.png

image.png

image.png

image.png

 

If I create a ticket with the right summary, the lookup find the issue, bu also a mail will be send.

 

image.png

 

image.png

 

I don't understand what happens?

Regards.

Ah!  Smart values are usually case sensitive, and unfortunately do not show errors when you get the case incorrect.  The smart value for Lookup Issues uses camel-case:

{{lookupIssues.size|0}}

 Please change your condition and see what happens.

Hi Bill,

I have changed it, and it works now. Thank you very much for the support.

Regards,  

Evert

Like Bill Sheboy likes this

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Apps & Integrations

Send an Email or Publish to Confluence - What should you do with your release notes?

Background When you hear the words ‘Release notes’, almost always you think of an unsolicited email from a software vendor. But I am here to tell you that from our data, sending release notes via E...

122 views 1 2
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you