Hi there, I need help writing a JQL search on scriptrunner

[Candice Irwin]

I need help writing the follow JQL  in scriptrunner please:

I need to search project 

Issuetype = Story

Linked Issuetype = Bugs/Defects only

column to show number of bugs open and closed

Fixversion = "V1(Day 1)

Order by labels ASC

[Andrew Wolpers]

Hey Candice, I would suggest using `issueFunction in linkedIssuesOf()`, which would look something like:

issuetype = Story and issueFunction in linkedIssuesOf("issuetype = bug") and fixVersion = "V1(Day 1)" ORDER BY labels ASC

If you're using `Defect` as well you would just update your JQL in the sub query.

The column(s) would be dependent on your gadget or filter, but the separation of open and closed issues that are linked to the Story might not be something Jira supports out of the box.  

[Candice Irwin]

Thank you for your help.

When I put this JQL in, I am retrieving all linked issues including "Change Requests", whereas I only want "bugs" listed. Is it also possible to have another cell for each story on number of "bugs" opened and number of "bugs" closed?

Thanks

Candice