Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How to query "is a successor of" and "is a predecessor of" ?

Michael Ellis July 26, 2021

I'm looking to create a filter to look for values if the linked issue fields are not blank?

 

In other words, if a story has a value for linked issue and predecessor or successor is selected, how can I list all of those issues? Or maybe just query where the linked issue/predecessor has a value in it.

 

Thank you.

 

 

2 answers

1 accepted

2 votes
Answer accepted
Jack Brickey
Community Champion
July 26, 2021

I am unfamiliar with successor and predecessor terms. Is it possible that you have created link types with these names? 

to query for issues without links - issuelinktype is not empty

to query for issues with links of type “successor” - issuelinktype = successor 

0 votes
Michael Ellis July 27, 2021

Annotation 2021-07-27 095107.pngAnnotation 2021-07-27 094855.png

When you're on issue view screen, and you click on link issue, there are a number of option, one being a successor of and another is predecessor of.   I can't figure out a way to create a jql query for this field.  Once you chose a value, the issue will have the field populated similar to:

 

Annotation 2021-07-27 095411.png

Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 27, 2021

Have you tried the JQL (advanced search) that Jack suggested yesterday?

Michael Ellis July 27, 2021

Hi Nic. Yes I did.  It worked, kind of with a modification seen here:

issueLinkType = "is a successor of"

The is not empty returned a huge list of issues with no visible values at all in the linked issue field.

Unfortunately the results aren't what I was hoping for.  I intended to use the query for a dash app to display dependencies but I was hoping to see some of that is a predecessor or is a successor of text in the response.  Instead I get:

 

Annotation 2021-07-27 143628.png

I'll have to settle for 1 filter for successor of and label the app so and one for predecessor as well.  Would be a nice ootb app I'd imagine people would be interested in built around the links field and specifically around dependencies but, I can work with this by making the query more robust to only grab linked items != done or something. 

 

So thnx Jack.  You got me on my way.

Suggest an answer

Log in or Sign up to answer