Trying to find issues with no child links

[Donald Jones]

I am trying to write a query that finds all issues in a project which have no 'is parent of' links to a child issue.

The only JQL function that I have found which lets me query links for an issue is linkedIssues(key), or linkedIssues(key,type).

However I cannot make this work.

It seems that I need a Query function which works as:

getLinkQty()

or getLinkQty(type)

In both cases it would return the number of links of type that an issue has.

This would let me build a query such as:

project = LFEAT AND issuetype = HLR and getLinkQty('is parent of')!=0

Is there such a function available, or is there an alternate way to build a query in JQL which can satisfy this?

Curently using JIRA 4.1, but upgrading to JIRA 5.0 soon.

[Danielle Zhu · Accepted solution]

JQL Tricks plugin should do the trick. It's a paid plugin though. It looks like Search Linked Issues for JIRA will also work for you:

issue in/not in linkedIssuesFromQuery("JQL query", "relation name","direction of relation") - finds all issues which are linked by w specified relation with those found by specified query

[Donald Jones]

I went with the Search Linked Issues for JIRA solution and after a bit of head scratching managed to get it to work.

Thanks for the quick answer.

[Danielle Zhu]

Glad it worked!

[Pete Singleton]

Strange that this thread says "Solved" but there is no solution posted!!