Searching for issue linkages

[Ashar Malik]

Hi All, I want to search for all issues of type Requirement (a custom issue type that we created) that does not have at least one link (of any type) to an Issue of type Story or Task. Thanks.

[Daniel Turczanski - JQL Search Extensions]

Hi,

With standard JQL, you can only get a list of issues with links and export them to Excel for further processing. This works if you want to do a one-off analysis.

Standard JQL doesn't easily allow it, but you can quickly find the results using our professional indexing service:

• JQL Search Extensions

After you install the app, you can simply search:

type=Requirement and linkedIssueType not in (Story, Task)

Check out the documentation to learn more.

I hope this helps!

Daniel

[Ashar Malik]

Thanks, this seems like a great solution. I have to reach out to our admins for install and procurement type guidance.

and yes, right now, I am exporting for one off analysis and even there, the approach is not that friendly as the export routine just dumps all links in multiple columns without indicating the issue type (at least that's what I think). This makes it very hard to figure out if the requirement is linked with a story and/or task or just with another requirement.  

[Daniel Turczanski - JQL Search Extensions]

Hopefully, it solves your problem. You can always contact our support and we can help with specific requirements and queries.

[KAGITHALA BABU ANVESH]

Hi @Ashar Malik ,

with default jira settings it's not possible.

If you look into above "IssueLinkType" not allowing "is" or "is Not" are allowed.

If you have script runner there is a chance: by executing the following JQL

issuetype = X and issueFunction not in hasLinks()

Thanks,

Kagithala Babu Anvesh

[Ashar Malik]

Thanks Kagithala, I am not familiar with script runner. Can you please elaborate?

Regards