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 · Accepted solution]

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

[Capps]

Thanks @Mike Bowen , that is an excellent idea and super useful :)

[Deepanshu Natani]

Hi @Capps ,

If the above answers have been able to clarify what you were looking for, please accept the answer(s) so that this thread can be referred by users looking for similar answers in future.

[Deepanshu Natani]

Hi @Capps 

Try the query:

status = Open AND assignee in (<username>)

in the above query, replace <username> with your username in Jira.

Check out following links for more details on JQL:

https://confluence.atlassian.com/jirasoftwarecloud/advanced-searching-764478330.html

https://www.atlassian.com/blog/jira-software/jql-the-most-flexible-way-to-search-jira-14

[Capps]

thanks @Deepanshu Natani 

[Andrey Khaneev _StiltSoft_]

Hi Gary,

This query should work:

resolution = Unresolved AND assignee in (currentUser()) 

[Capps]

thanks @Andrey