I want form a JQL query where i can check if my user story is linked with a Test Plan or not?Can you

[saurabhi mahakalkar]

I want form a JQL query where i can check if my user story is linked with a Test Plan or not?Can youhelp?

Since both are issue type,how should it be used in query to get exact result?

[Jack Nolddor _Sweet Bananas_]

Hello,

Are you using standard issue linking feature to link both types?

[saurabhi mahakalkar]

thinking to,do you have sample query to do this?

[Jack Nolddor _Sweet Bananas_]

Hi Again,

If you are using standard link features, you cannot achieve the desired search using standard features on Jira, you must go for a third-party app instead. Using i.e. JQL Booster Pack you can type the following:

1) Search 'Story' having links to 'Test Plan'

project = XXX AND type = Story AND issue IN linkedIssuesOf(' project = XXX AND type = "Test Plan" ')

(*) Note that this is just an example, you must tune above query to fit your needs.

Using this app you can also query other issues relations, check:

• epicsOf()
• hasSubtasks()
• issuesInEpics()
• linkedIssuesOf()
• parentsOf()
• portfolioChildOf()
• portfolioParentOf()
• subtasksOf()

References:

• Official documentation

Hope this helps you to create awesome queries <3

[saurabhi mahakalkar]

Thank you so much! I wrote a whole query in subquery-thats where it went wrong i guess..

Also I was looking for queries that bring up list of user stories that have execution missing or execution completed,both...

[saurabhi mahakalkar]

project = XXX AND type = Story AND issue IN linkedIssuesOf(' project = XXX AND type = "Test Plan" ')

This isnt working but.... some syntax errors

[Jack Nolddor _Sweet Bananas_]

Could you please copy/paste the whole error?

[saurabhi mahakalkar]

Error in the JQL Query: Expecting ')' or ',' but got '='. (line 1, character 126)

[Jack Nolddor _Sweet Bananas_]

Query is working OK at my end... hmm have you tune the query in any way?
Do you mind to share with us an screenshot having the whole query and the error to figure out what was wrong?

Regards