Community
Q&A
Jira
Questions
I need jql to filter epics without linked issues under

I need jql to filter epics without linked issues under

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.

2 answers

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

0 votes

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Richard,

Thanks for the reply, but the query is not working

Capture 1.PNG

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

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

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

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.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 votes

Error Screenshot 1.PNG

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Was this helpful?

Thanks!

Jira

DEPLOYMENT TYPE

SERVER

Forums

Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

I need jql to filter epics without linked issues under

2 answers

Comments for this post are closed

Was this helpful?

Thanks!

DEPLOYMENT TYPE

TAGS

Community showcase

Atlassian Community Events