What type of field is "Linked issues"?

Question

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!

rodney e · Answer

Hi @Ravina ,

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

rodney e · Answer

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.

Jack Brickey · Answer

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?