How to display Jira issues on a confluence page

Capps

Im trying to add all open issues that are assigned to me on a confluence page.

Im trying to use the Jira macro for this and I know this search query is incorrect but its very much what I am trying to achieve.

https://share.getcloudapp.com/P8uY67YE

1. What is the correct search query?
2. Where do I find samples of search queries so I can refine and or adjust as required?

TIA

Mike Bowen

Hi @Capps 

The above two solutions definitely work, but I have another way you can do this and it will help you learn JQL quickly. 

1. In Jira, click on the Search icon in the left toolbar. 
2. Select Filters at the bottom.
3. Click Create Filter button (top right). 
4. Select your Project, Type, Status, Assignee and any other criteria through the +More pull down.
5. Click the Search button. See results. 
6. Now click Switch to JQL and you can see the script. 
7. Switch back to Basic if you want to change stuff, or try out the script yourself (it is actually very easy once you use it). 
8. Save the filter - Give it a name and note the ?filter=xxxxx number. 
9. An extra step in the save could be to Share the filter with your colleagues or a group. 
10. In Confluence add the ?filter=xxxxx number to your Jira Macro and voila you have your results. 

Filter - Basic View:

Filter - JQL View:

 

-Mike