Can someone please help how to extract Jira requirements which don't have linked stories to it.

[Aneeka]

I want to write a filter which helps me  extract Jira requirements which don't have linked stories to it. Any pointers how I can do that?

[Pramodh M]

Hi @Aneeka 

Welcome to the community 🙂

issuetype = Story and "Epic Link" != EMPTY

If you are tracking the Requirements via Epic and you have stories linked to it.

The above JQL will return the stories which doesn't have the Epics

Let me know the exact requirement if it doesn't work

Thanks,

Pramodh

[Aneeka]

Thank you @Pramodh M .  Let me try that.

[Aneeka]

I will update you on that soon

[Aneeka]

what I am trying to do is 

type = requirement and linked issue is not stories.

how to query second part

[Pramodh M]

@Aneeka

Can you try with this let me know if this works

issueLinkType is not EMPTY and issuetype != "Story" and issuetype = "requirement"

Thanks

[Aneeka]

working like a charm. Thank you so much for your help

[Aneeka]

A quick question @Pramodh M 

while writing AND in filter

issuetype = requirement and( issueLinkType is not EMPTY and issuetype != story)

does it take precedence in evaluating expression from left to right or all the and expressions are evaluated at same time.

e.g.

A and B and C

A first then B then C 

or 

all in parallels.

[Pramodh M]

@Aneeka 

Brackets are evaluated first and then all the expression are evaluated

AND takes the precedence over the other keywords

Thanks

[Aneeka]

@Pramodh M  what I am trying to ask is if there are multiple AND statements how are those evaluated.. See my last comment. Bracket part , I am clear.

Thanks

[Pramodh M]

@Aneeka 

A AND B then C

[Aneeka]

@Pramodh M thank you

[Aneeka]

@Pramodh M 

issueLinkType is not EMPTY and issuetype != "Story" and issuetype = "requirement"

This is still returning stories in linked issues. Do you see why?

[Pramodh M]

@Aneeka 

Include the issuetype JQL as 

issuetype not in ("Story") and whichever the issue type you do not need

Let me know if it works 

[Pramodh M]

Hi @Aneeka 

If you are okay with just searching the issues which have empty links

go with this

issueLinkType is EMPTY and issuetype = "requirement"

For linked issues to be searched, it's something complex and might need add-on

Thanks,
Pramodh

[Aneeka]

nope. still the same . It is returning requirement which  has story type in linked issue along with other issue type. 

what I want is 

project = x and type = requirment and linked issue type != story

Ideally your suggested query should work but it is not 

[Pramodh M]

@Aneeka Can you please include the screenshot on the same, how you are getting the result?

[Aneeka]

I searched with

project =xxxx AND type = Requirement AND issueLinkType != EMPTY AND issuetype != Story

result was -   list of all issues with type requirement , 

when I open some of them , I get

in linked issue -

issues which are tagged as story and other issue like requirements, change request .

[Pramodh M]

Yeah for the linked issues of type Story we need to use Scriptrunner add-on or JQL for extensions

https://jqlsearchextensions.atlassian.net/wiki/spaces/SEARCH/pages/173211649/Subqueries+-+Jira+Cloud#Subqueries-JiraCloud-linkedByQuery