Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

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

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.

1 answer

1 accepted

1 vote
Answer accepted
Ivan Lima Community Leader Jun 06, 2022

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:
| {{key}} | {{summary}} |

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

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


- {{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 :) 

Like Ivan Lima likes this

@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 Community Leader Jun 07, 2022

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:

Suggest an answer

Log in or Sign up to answer
Site Admin
Community showcase
Published in Jira Service Management

Coming Soon: Insight Changing to Assets

The 2020 acquisition of Mindville added powerful asset and configuration management capabilities to Jira Service Management in the form of Insight. Following the completion of that integration, custo...

479 views 3 13
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