Hi all, We're trying to create reports/dashboards revolving around issues with the most Issue Links. I emailed in to Atlassian and received the following response: I don't believe this is currently possible out-of-the-box although we are considering working on a similar feature. The way to work around that would be for you to write a dedicated sql query directly against the JIRA database to get this information. We're using OnDemand, and it's my understanding that you can't directly query the database. I then thought about using CustomWare to send data to Salesforce and report from there, but no. This is from their support team: Thanks for the screen shot and the explanations. It's not possible to do that with the connector.As you probably know, for OnDamand platform you only can query with the basic JQL functions but you can vote here for the new JQL features. So how can I get at this data? Our end goal is to create a dashboard (graphs) outlining the issues with the most number of issue links or related issues, and break it out by which aspect of the business it affects. Thanks in advance for your expertise.

Community
Q&A
Jira
Questions
Creating reports based on number of issue links

Query two-levels hierarchy in Jira

Hello,

Can you please help me with Filter query, that is searching for all issues, that belong to the epics, which, in its turn, are children of one specific ticket of type Initiative?

I can for example find all epics of the initiative with this query "Parent Link" in (initiative_id)" or to find all issues of epic with this query "Epic Link" in (epic_id)", but I don't understand how to put one query into another. It seems that JQL doesn't support such functionality.

Can you please give me some hints for this problem?

Thank you,

Natallia.

2 answers

1 accepted

1 vote

Answer accepted

Hi Tyler,

While it would require some additional development you can query issue links from the REST API using the following example:

curl -D- -u &lt;user&gt;:&lt;pass&gt; -X GET -H "Content-Type: application/json" https://&lt;instance&gt;/rest/api/latest/search?jql=project=&lt;projectkey&gt;&amp;fields=summary,issuelinks

From the response, you would want the data within "issuelinks", "outwardIssue" and "inwardIssue"

Cheers,

Paul

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

hmm, is 'additional development' an option for OnDemand? I would love to be able to filter my kanban swimlanes based on number of blocking tickets.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 votes

Hi Paul,

I am new to JIRA cloud and trying to find some way to query issue sin JIRA which can show me some specific filed (version) for linked issues .

Came across your answer and tried but i m not sure how to use it in this scenario to achieve my goal and how to view the output inside JIRA interface ?

Can you please tell me where to fire this curl command to view o/p inside jira?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi An, the answer above is external to JIRA. The command uses the REST API to return the results to your command line. I don't believe issue link queries can be run inside JIRA via JQL.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Does anyone know if this has been resolved as of October 2018?

Thanks

Glenn

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Forums

Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

Query two-levels hierarchy in Jira

2 answers

1 accepted

Suggest an answer

Was this helpful?

Thanks!

TAGS

Community showcase

Atlassian Community Events