How to create jira query and post the result in a confluence page?

I would like to know how to present query for each of project participants in a table format and then post it on a confluence page? For intance

Name|Number of open tickets|Number of closed tickets|Total number of tickets|

John 10 20 30

Peter 5 0 5

If I click on 10, a result of tickets for John will displayed. How can I achieve this? Please advise.

1 answer

0 votes

Use Jira issue Macro ..Please have a look at the below KB.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Thank you for speedy speedy reply. Do you happen to have a link for JIRA Macro? It can be handy as I don't know about JIRA Macro.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Go to the confluence page and just you need to add this macro and select the filter.

It will display the result on the confluence page.

please go through the linked KB, you will get more details.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Thank you again for your information, Yogesh. I'll give it a try.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.