i would like to perform join in a custom JQL query like join in SQL.
select * from typeissue1 left join typeissue2 on typeissue1.related_id = typeissue2.id and typeissue2.field_name != ''
in that case, i want all the issues from issutype1 and issetype2 that have the same value in a certain fields and another where query.
there is any good tool to do that instead of Jira Advanced search? any recommended app?
Hi @Maor Avitan ,
Please review the following threads and see if you can get the desired results which you are looking for.
You can vote on this request, https://jira.atlassian.com/browse/JRASERVER-25833
For JSM June Challenge #2, share how your non-technical teams like HR, legal, marketing, finance, and beyond started using Jira Service Management! Tell us: Did they ask to start using it or...
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