Looking for a report that link project tickets with external

[Sagar Dave]

Hello Team,

We have a project in Jira which is hosted on server and for the client reporting we do use Zendesk. Once the ticket is created by the customer it is linked with the relevant project in Jira. We are looking for a report that is extracted out of system as we are looking to build some reports with the same. Could you help us to guide what exactly can be done. Either with the doc generator or any report will be a great help.

[Danny]

Hi @Sagar Dave

Just to clarify, you are looking to run a tabular report from Jira server to display a ZenDesk web links against each Jira ticket. Is that correct?

Thanks,

Danny

[Sagar Dave]

Thanks Danny for the quick check, Yes exactly that is what we are looking for.

Thanks.

[Sagar Dave]

Hi Danny,

Any updates?

[Danny]

Hi @Sagar Dave 

Unfortunately, from what I have researched, this is not possible to query via JQL web links against issue tickets. 

Not the best news.

There are other options though:

1. Requesting the ability to perform a JQL search and retrieve a list of remote links to eg: Confluence and other applications as a new column in the issue browser.

This is already in the REST API eg:
http://localhost:8080/rest/api/latest/issue/TST-1/remotelink

Reference is here

2. You could add the web link to a text custom field once the issue is linked, so you can use the JQL query to search on the custom field.

3. You could sign-up for ScriptRunner add-on and use the parameter linkedIssuesOfRemote to search for Web links, as described in the section Remote Issue Links of the documentation.

Original thread here. 

Hopefully this help,

Danny