Is it possible to create a JQL with clauses similar to "SQL join"?

Question

I have epics, with labels, and issutypes.

Ex:

Epic 1

Label: Label1

related issutypes: Issu 1, Issu 2.

I want to do a JQL that bring to me all issutypes that the epic related in "Epic Link" have the label "Label1".

The issutype has no labels, just the epic.

Is it possible?

Nic Brough -Adaptavist- · Answer

Joins are for joining tables together, Jira does not do this because it is not table driven.

What you describe does not need SQL0like joins, it only needs logical operators.  Adding "and label =" is the right thing to do, but you've forgotten to add the clause that selects for "and epic's label is".

Muhammad Ramzan_Atlassian Certified Master_ · Answer

If i correctly understand your problem ,you want to search epic  with a specific label and this epic will than display the issue under the epic. Your epic have the labels but issues linked to the epic does't have the label right?

If this the case, then following query would really helpful for you , its supported by a third party plugin which i am using for my queries and its amazing. You can find the plugin here

Following query will return the all epics with issue type = story and label = epic1

issue in epicOf("issuetype = Story") and labels in (epic1)

Thiago Vilela · Answer

I think you don't understood me. I should list in JIRA the issues below the Epic that have a especific label. The label is on epic. If I just use "and label = label1" the search will bring 0 results, because my issues have no label.

Anyway, thank you for the answer.