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

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,460,632
Community Members
 
Community Events
176
Community Groups

how to query and present two related objects's attribute in Jira

I have two related objects A, and B (parent, child in jqjquery) and would like to present some attributes of both A and B in an UI or at least a jql query, like the logic below:

A.key, B.summary, B.status where A is parent of B

 

how can I do so with jqlquery or other means in Jira? 

 

further more, I would like to present the result in a GUI gadget and it seems the out of box dashboard can not do it.  

what plugins would you recommend for the GUI purpose?

 

thanks.

 

1 answer

0 votes
Rachel Wright Community Leader Jun 15, 2021

Hi @CyberSage ,

I think my answer is the same for your use case as I added for this question: https://community.atlassian.com/t5/Jira-questions/JQL-query-help-with-Initiatives-and-subtasks/qaq-p/1725998#U1726028

You can't do nested/joined/cascading/subquery (or whatever else you might call this) queries out of the box.  You can do this through the REST API, but as I mentioned in my other comment, I brought Jira down doing it, so be careful.  

Since you have Jira Server, you could certainly fetch this data from the database, but that doesn't help you display it in a native dashboard gadget, as you'd like to do.  What if you fetched the data and dumped it to another location that you linked to from your dashboard? I know, not pretty but it might be a possible/temporary solution.

Also, check the Atlassian Marketplace to see if someone has built something that would suit your specific needs.  See: https://marketplace.atlassian.com/search?hosting=server&query=jql  Lots of us could use more JQL abilities so something may exist or might be on the way in the future.

Good luck,

Rachel Wright
Author, Jira Strategy Admin Workbook

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events