Hi,
We have two projects like project A and project B. The Project A issues are linked with the project B issues with different issue types. We need only story issue type issues in project A.
How to write JQL for this?
Hi @Raghavarapu
Welcome to the community.
This is not possible OOTB, you'll need an addon like scriptrunner to achieve this.
https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html
Welcome to the Atlassian Community!!
Sorry to say but you cannot achieve the desired search using standard features on Jira,
you need go for a third-party app instead.
This are third party app that can help you to achieve the your desired result.
JQL Booster Pack
JQL Tricks Plugin
JQL Search Extensions for Jira & reports
ScriptRunner for Jira
Search Linked Issues
Find issues in one project linked to another project , i.e.:
project = "My Project" AND issue IN linkedIssuesOf(' project = "Other Project" ')
linkedIssuesOf
Note that this is just an example, you must tune your query to fit your needs
Using this app:
you can also query other issues relations, check:
References:
Hope this helps you to create awesome JQL.
Regards,
Mayur
we have scriptrunner add on
how to write expression in jql
@Raghavarapu Use JQL functions from ScriptRunner that are used for searching for linked issues. Check in the ScriptRunner documentation onlin
Some of them might be (if I remember correctly): hasLinks(), linkedIssues(), etc.
The way to use these JQL functions from ScriptRunner in a JQL query is as below as an example:
project = "your-project" AND issuetype = "Story" AND issueFunction in linkedIssues("your-arguments-for-this-JQL-function")
The JQL query needs to be created in Issue Navigator screen which is accessible using "Search for Issues" link from the Issues menu in Top Navigation menu (Note: the way to access Issue Navigator screen might be different for Server/DC and Cloud editions of Jira)
Hope this helps!
Hi ya! This is Jack from SweetBananas,
Thanks for the kind shoutout!
It looks like you're new here. Sign in or register to get started.
![Photo of Jack Nolddor [Sweet Bananas]](https://us.v-cdn.net/6038660/uploads/avatars/b3/a6/nb3a6df9986a0e0eba72ad4e75c0a61f5.png)
