Filtering out All Links (Child of & Parent of)

[Steven Do]

Hi,

I'm trying to create a JQL filter that will remove all the tasks that are linked (child of, parent of, etc.). I've tried using the following:

issueFunction not in hasLinks("child of") AND issueFunction not in hasLinks("parent of")

But it still returns tasks, sub-tasks and issue with links (parent of or child of). 

Goal: to be able to have a folder in structures that will return all tasks and issues that need to be linked. 

Thanks!

Best,

Steven

[Mohamed Benziane · Accepted solution]

Hi @Steven Do 

If you want to find all issue without subtask you can try :

issueFunction not in hasSubtasks()

If you need to find all issue without link (like, block, duplicate clone, etc..) you can try

issueFunction not in hasLinks()

Hope this helps

[Steven Do]

Hi @Mohamed Benziane

I did try what you had suggested already and it'll still provide tasks that have parent or child links. 

Best,

Steven Do

[Steven Do]

This mostly works but I still get some tasks that show up that has links. Still investigating but this is the closes to a solution.

[Olga Videc]

Hello @Steven Do 

You must have Jira 8 or higher for this JQL

issueLinkType not in (causes, "relates to", duplicates, blocks, "is blocked by", clones, "is cloned by", contains, "is contained in", "is depended on by", "depends on", "is duplicated by", "FF-depends on", "is FF-depended by", "Linked one can't finish until this issue is done.", "can't finish until the linked issue is done.", "FS-depends on", "Linked one can't start until this issue is done.", "can't start until the linked issue is done.", "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", "is caused by", "SF-depends on", "is SF-depended by", "Linked one can't finish until this issue begins.", "can't finish until the linked issue begins.", "SS-depends on", "is SS-depended by", "Linked one can't start until this issue starts.", "can't start until the linked issue starts.", "is parent task of", "is subtask of")

OR

To achieve this with script runner function you need to combine this with hasLinkType and hasLinks

BR, Olga

[Steven Do]

@Olga Videc 

Unfortunately, I'm on 7.13.2.

Can you provide more information on the hasLinkType or hasslinks function?

Thanks!

Best,

Steven Do

[Ilya Turov]

Hello,

are you trying to filter out issues without subtasks, or is "parent of"/"child of" - issue link type?

[Steven Do]

@Ilya Turov ,

I'm trying to filter out all issues/tasks that have links associated with them. The goal is to be able to see what tasks/issues need to be associated.