linksHierarchyFilter with only cloned by issues

Hi there we are using the linksHierarchy plugin and we would like to make a JQL filter that has the following structure:

Project A has a filter 12706,a and we like to fined all closed issue form Project B to Project A

we wanted to use this filter:

linksHierarchyFilter(12706, 3,ouward,"is cloned by")

but still it finds also Relates To issues, we would only like to have the Is Cloned by Issues

according to the documenentation this is possible, but not told how the parameter 3 -> Link direction and 4 -> Linke type should be filled, i have tried a lot of differnt options but all did not give the wanted end result

2 answers

The JQL parameters works by EXCLUSION. It means everything is included by default unless you explicitely exclude it.

Leaving any parameter empty means "ALL".

Hence, you might try:

linksHierarchyFilter(12706, 3,inward, "relates")

in order to exclude inward linked issues and relates link types.

linksHierarchyFilter(12706, 3,"", "relates")

would ignore the link direction (it means all the inward and outward links would be included).

You can get the required link type names parameters easily by moving the mouse over the link node on the tree graph. For instance, for a "is blocked by" linked issue it would by "Blocks" or something similar.

This is a helpful tidbit - especially the required link type names. You can find this in Admin pages under the Issue Linking page. This JQL filter is expecting the values in the "Name" column. Now, I am trying to figure out how to exclude more than one link type.

Hi Dennis,

Can i suggest :

https://marketplace.atlassian.com/plugins/pt.lt.lfcribeiro.jira.jqlLTFunctions

Theres a function "ExecuteQuery()" that lets you run a SQL statement and also functions on linkedfilters

Regards,

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,345 views 14 20
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot