How to find issues with JQL

[Raghavarapu]

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?

[Mayur Jadhav]

Hi @Raghavarapu 

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" ')

Note that this is just an example, you must tune your query to fit your needs

Using this app: 

• JQL Booster Pack

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 JQL.

Regards,

Mayur

[Jack Nolddor _Sweet Bananas_]

Hi ya! This is Jack from SweetBananas,

Thanks for the kind shoutout! <3

[Taranjeet Singh]

@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!

[Mohamed Benziane]

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

[Raghavarapu]

we have scriptrunner add on 

how to write expression in jql