I need jql to filter epics without linked issues under

Question

Hi,

I need jql query to filter epics without linked issues under and "epic link" is also should empty I mean the filtered epics should not have any kind of linked issue either "EPIC LINK" issues also. I'm using below qurey.

Kindly help on this issue.

project = "My Project" AND issuetype = Epic AND "Epic Link" is EMPTY AND issueLinkType not in (blocks,"is blocked by",causes,"is caused by",clones,"is cloned by",duplicates,"is duplicated by","has to be finished together with","has to be done before","has to be done after","earliest end is start of","start is earliest end of","has to be started together with","split to","relates to","is related to")

Regards,

Sunil Kumar M.

Muddada Sunil Kumar - Vendor · Answer

Hi Richard,

The below query works, But we should have script runner.

project = "My Projects" AND issuetype = Epic and issueFunction not in hasLinkType("Epic-Story Link") AND issueLinkType not in (blocks,"is blocked by",causes,"is caused by",clones,"is cloned by",duplicates,"is duplicated by","has to be finished together with","has to be done before","has to be done after","earliest end is start of","start is earliest end of","has to be started together with","split to","relates to","is related to")

Regards,

Sunil Kumar M.

Richard Cho · Answer

@Muddada Sunil Kumar - Vendor sorry, you don't actually need that field.

Try: project = "My Project" AND issuetype = Epic AND issueLinkType = EMPTY

Muddada Sunil Kumar - Vendor · Answer

Hi Richard,

Thanks for the reply, but the query is not working