Create a ticket with a table of selected tickets (list)

[Eugen G.]

Hi Community,

I was doing some research, but did not really find a clear answer.

Basically, I would like to have something similar to the "Subscription of Filters". But instead of the delivery to my mailbox, a ticket should be created with the listed tickets.

I.e., is there a standard way (w/o scriptrunner or addons) to

- automatically create a ticket

- and insert a list of tickets (selected within the automation with JQL or IQL) as table into that ticket

- (alternatively, I would be fine to have a CVS/Excel of that table attached to the ticket)

Thanks in advance.

[Ivan Lima · Accepted solution]

You should be able to do that with Automation for Jira. You could try something like:

• Trigger: scheduled
• Action: Lookup Issues based on your JQL
• Action: Create issue. You can use markdown to get the table format to iterate on the results. Example:

{{#lookupIssues}}
| {{key}} | {{summary}} |
{{/}}

There are limitations though. I recommend reviewing the documentation to make sure it will work for your use case.

[Łukasz Modzelewski _TTPSC_]

Thx @Ivan Lima ! I've just 'upgraded' my way of handling similar case :) 

Notes:

- {{key}} might be enough -> with Jira smart links it will hold the data for key, status, summary, in my setup I left the 2nd column to add notes to those tickets

- if you want check for cross-project work, this needs to be global rule - I started in my target project for this task but it wasn't returning any results, with global rule I got the expected results :) 

[Eugen G.]

@Ivan Lima That's a good suggestion.

In my case it will not work, though, because I need some custom fields to be displayed as columns. But you mentioned the "limitations".

I will try the IQL approach. I think, it should work. Will report, once I have it tested.

[Ivan Lima]

You can get custom field data as smart values, even if the issue in the JQL lookup won't return the custom field, which should show as blank.

For reference:

• https://support.atlassian.com/cloud-automation/docs/find-the-smart-value-for-a-field/