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

[Lawrence]

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.

[Yogesh Mude]

HI @Lawrence

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

https://confluence.atlassian.com/doc/jira-issues-macro-139380.html

[Lawrence]

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.

[Yogesh Mude]

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.

[Lawrence]

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