What type of field is "Linked issues"?

[rodney e]

Hi,

I'm just needing to document the field type and if possible, the limitations around searching by that field using JQL.

"Linked issues" (in JQL = issueLinkType)

Use case: Trying to search for tickets with only linked issues of "is blocked by" and in "Done" status. Currently search results include other linked issues types if it contains "is blocked by".

Thanks!

[Ravina]

Hi @rodney e To get the linked issues with specific linktype you can use the below JQL

issue in linkedIssues(ABC-123,"is duplicated by")

If you want a get all issues with Block type or "is blocked by" linked type you can use the below JQL but this will require a script runner plugin as some JQL functions are coming from that plugin

issueFunction in hasLinks("blocks") OR issueFunction in hasLinks("is blocked by")

Please check the below document for more details

https://support.atlassian.com/jira-work-management/docs/advanced-search-reference-jql-functions/#Advancedsearchingfunctionsreference-linkedissuelinkedissue

https://docs.adaptavist.com/sr4js/latest/features/jql-functions

Thanks

Ravina

[rodney e]

Hi @Ravina ,

Appreciate the response but I'm not able to use your JQL since I don't have Scriptrunner.

[Jack Brickey]

Hi @rodney e , linked issues is it really a field per se. However, you can achieve your use case by using the following.

Status = done and issuelinktype = "Is blocked by" and  issuelinktype not in (a, b, c, d...)

What you will need to do is to replace a, b, c, d... with every link type other than "is blocked by". That is the only way to get the "only" part of your use case.

[rodney e]

Hi @Jack Brickey ,

Thank you for the help. Your JQL works for isolating the needed "is blocked by" but I'm looking for "is blocked by" and in "Done" status. The issueLinkType and linkedIssueStatusCategory fields seem to be mutually exclusive.

My JQL:

project = ABC AND (issueLinkType = "is blocked by" AND linkedIssueStatusCategory = "Done")

[Jack Brickey]

So that I clearly understand your use case let's take the following example.

Issue A is linked to issue B. Issue A "is blocked by" issue B which means issue B "blocks" issue A.

For now let's assume that both A and B are in the done status. Which issue do you want your JL to find?

[rodney e]

I would like to find "Issue A" but if "is blocked by" is the only linked issue type in a "Done" status.

JQL doesn't seem to be able to isolate linked issue type with a status. It treats them separately.

EXAMPLE: Project = ABC AND (issueLinkedType = "is blocked by" AND linkedIssueStatusCategory = "Done")

RESULTS:

Issue A "is blocked by" Issue J. Issue J is "Done". <---EXPECTED

Issue E "is blocked by" Issue Q. Issue Q is "To do". <---UNWANTED

Issue E "relates to" Issue L. Issue L is "Done". <---UNWANTED

I don't think JQL can get that granular with "Linked issues". The next best thing is for me to document why, i.e. what is the schema for "Linked issues"?

Appreciate the help.