How to query JIRA within a confluence page?

[Lawrence]

Hi,

   I would like create JIRA result in a confluence page in a table format with the  column heading as following:

       | Assignee |  Total |

Under the total is the number of ticket being assigned to the person. When one clicks on the number under column Total,  it'll bring up a JIRA query result page with all the tickets that are assigned for the specific person.

   Can someone provide me a guide or tutorial on confluence on how to achieve that? 

Thank you,

Lawrence

[Victor Mutambuki]

Lawrence,

Please review the Jira issue Macro
https://confluence.atlassian.com/doc/jira-issues-macro-139380.html

victor

[Lawrence]

Ok, I'll give it a try. Thank you, Victor.