Automation - Sending an email containing multiple JQL search queries

[Liam Cass]

Good morning!

I am trying to create an automated email to send out meeting agendas every week. Each agenda that I make uses issues from five different JQL searches, and lists the results of each search in the email.

Currently, I am doing this manually, and the emails look like this:

-------------------------------------------------------------------
Good morning! Here are the topics we will look at today

[filter-one-name]
issue-result-1001    issue_summary_here   custom_field_value
issue-result-1002    issue_summary_here   custom_field_value

[filter-two-name]
issue-result-2001    issue_summary_here   custom_field_value

[filter-three-name]
issue-result-3001    issue_summary_here   custom_field_value
issue-result-3002    issue_summary_here   custom_field_value

I'll see you later!
-------------------------------------------------------------------
And eventually I was thinking about using HTML in the emails to make the columns prettier.

So far, I looked into using an automation rule to send an email, however I was only able to produce something like the below, using results from a single JQL search and the {{issues}} smart value.

-------------------------------------------------------------------
Good morning! Here are the topics we will look at today

[filter-one-name]
issue-result-1001
issue_summary_here
custom_field_value

issue-result-1002
issue_summary_here
custom_field_value

I'll see you later!
-------------------------------------------------------------------

I am not quite sure how to send an email and include information on more than one search query. I've also looked into using filter subscriptions as a way to compile and send filter results, though I don't know how to automatically compile more than one filter result into an email, AND to include a header and footer.

I was wondering if there was any way in out-of-the-box Jira to automate sending these emails?

If it is not possible for out-of-the-box Jira, I also have access to script runner, and would appreciate some tips on making a script for this automation!

[Hossam.Khalil]

Hi There,

The problem still exists till this day.

We have upgraded to Jira 9.12.8 DC and we still get the same error.

Deleting the Cache and Safe mode solutions do not work.

Does anybody have an update regarding this issue?

BR

Hossam

[Daniel Cosmus]

I had the same problem by creating a new plugin. I was able to fix it, by deaktiviating "AdBlocker" for my Jira instance.

[Ivan]

I do meet the same issue

Go to manage apps, enter safemode and  try to see if issue fixed.

If yes, you can try to enable your plugin one by one, so you can find what the issue is.

I had use this to resolve similar issues.

[Alice Ark]

Hi,

In JIRA 7, the wiki editor is native, included in System plugins. I do not need to reinstall the wiki plugin.

You can see it by browsing system plugins :

At the end of the list :

When upgrading to JIRA 7, we were having the same issue as you, with en error message in Agile views, because of this plugin.

To resolve it, we did disable/enable the wiki editor (of System), AND we waited for the JIRA cache to be cleared.

We presumed that it was the cache because the error disappeared after waiting a moment. We are not even sure that disabling/enabling the add-on was helping.

It seems to be a conflict between the wiki add-on and the system add-on.

Perhaps you can try this :

- Before the upgrade, remove wiki add-on

- Upgrade to JIRA 7

Hope that helps.

Alice

[nbr_operative]

We recently upgraded Jira Standalone version from 6.3 to 7.11. We are facing a similar issue. We tried disabling and enabling wiki-editor but that did not work. 

Do we know how to resolve this issue?

[Tom Christensen]

Hi.

We have the exact same problem in our new installation of JIRA 7.10.2. It hasn't been put into production yet, so I would appreciate a feedback on this issue from anyone with a possible solution.

Brgds