It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to display Jira issues on a confluence page

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 :)

4 answers

1 accepted

0 votes
Answer accepted

Hi @Operations 

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 = Basic View.png

Filter - JQL View:

Filter = JQL View.png

 

-Mike

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

Like Mike_Bowen likes this

Hi Gary,

This query should work:

resolution = Unresolved AND assignee in (currentUser()) 

Hi @Operations 

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

0 votes

Hi @Operations ,

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.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Confluence

What project did you transition or start on Confluence with the shift to remote work?

It’s been great to hear from fellow users over the last few weeks about the best tips and fun moments you’ve had working on Confluence since the transition to working remote. I’d love to keep the c...

353 views 11 11
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you