Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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 @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 = 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 @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

0 votes

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.

Suggest an answer

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

What do you think is the most *delightful* Confluence feature? Comment for a prize!

- Create your own custom emoji 🔥 - "Shake for Feedback" on mobile 📱 - An endless supply of GIFs via GIPHY 🤩 Is there anything quite as nice as a pleasant surprise? Comment below with what...

480 views 24 9
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