I need jql to filter epics without linked issues under

[Muddada Sunil Kumar - Vendor]

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.

[Richard Cho - ServiceRocket]

Instead of enumerating every possible issue link type, you can just do issueLinkType is EMPTY

Also, the use of 'Epic Link' will be deprecated soon. You should instead be using the 'Parent' field instead (link).

Final query would be:

project = "My Project" AND issuetype = Epic AND Parent is empty AND issueLinkType = EMPTY

[Muddada Sunil Kumar - Vendor]

Hi Richard,

Thanks for the reply, but the query is not working 

[Richard Cho - ServiceRocket]

@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]

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.

[Muddada Sunil Kumar - Vendor]