JQL - how to perform join in jql query in Jira Cloud?

[Maor Avitan]

i would like to perform join in a custom JQL query like join in SQL.

for example:
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?

[Eli Andrade]

Please help me.

I need to give a result query where the parent (feature) have some condition and the soon (stories) don't have or have the same condition. 

There's any solution at JQL to resolve this problem?

[Amith Mathur {Appfire}]

Hi @Maor Avitan , 

Please review the following threads and see if you can get the desired results which you are looking for. 

JOIN with an advanced seach in JQL 

Multiple JQL queries in a single report 

Selecting quot OR quot value of multiple filters 

You can vote on this request, https://jira.atlassian.com/browse/JRASERVER-25833

Thanks,

Amith Mathur

[Maor Avitan]

Hi, none of this is good for me,
i need to do it on Jira Cloud and not Jira server