JQL Query for linked issue not working as expected.

[Jenifer Kuntz]

I am creating an automation rule and doing an issue lookup with the following JQL

issue in linkedissues({{issue.key}}) and issueLinkType in ('parent story')

What I expect it to do was pull the issues that were linked to the issue with a parent story link type.

What it is doing is pulling the the issues linked to the issue then looking at those issues and seeing if they have a parent story link.

I put the query in the navigator with the same results.

issue in linkedissues("ISSUE-123") and issueLinkType in ('parent story')

For example 

My issue ISSUE-123 has the following linked issues:

ISSUE-124 (parent story Link)

ISSUE-125 (relates to Link) This issue has a parent story link to ISSUE-111

ISSUE-126 (relates to link) No Parent story link.

The quesry is pulling all three issue.

I am adding a number field from the linked issues. In this case I would Only want it to look at ISSUE-124 but it is adding the value from ISSUE-124 and ISSUE-125 because they both have parent story links.

Any idea on how I can have it only pull the parent story link of the initial issue.

Thanks!
Jenifer

[Prem Chudzinski [extensi] · Accepted solution]

Go to the backlog and select Mark as Done option from the small icon.

Status is not epics status which is used by epics backlog list.

[Deleted user]

Thanks.. Indeed. The EPIC Status (which is a JIRA default field & not in the form) that cause the problem. 

Thanks.

[PADMA KOTHAKOTA]

Hi Abhipsa,

If the issue is not visible in the board there may be 2 reasons one may be with the filter and another  may be the Rejected status is not mapped to the column in the board.

-->Check the filter  if the filter is like project = xyz and status != rejected. it will show only those issues in the board which are not in rejected status

--> check the status is mapped to the column

Go to Board--> configure--> Columns--> Map the Reject status to the column.

[Deleted user]

@PADMA KOTHAKOTA

I mentioned the issue is showing. That to at EPIC panel of the board, which is not normal as the Rejected status filter is mentioned for the board in such a way that the EPIC should not visible.

So the above answer is not my answer.

[PADMA KOTHAKOTA]

Hi @[deleted],

Can you try with the below filter in your board. It will not show epics which are in rejected status in Epic backlog board

project = xyz and issuetype = Epic and status != Rejected

[Deleted user]

@PADMA KOTHAKOTA

No. I think you are not understand my problem properly.