Listing "Connected JIRA issues" from Insight in Confluence with iql

Question

Hello,

We have Insight 6.3.6 with JIRA 7.13.x and Confluence 6.13.x.
In one new project where we have integrated objects from Insight in JIRA through a custom field, we want to put in a Confluence page an iql query which can list all "Connected JIRA Issues" from all our Insight objects of one objectType.

I have found that a query like this can tell us which are the insight objects with an open issue:

objectType == "ExampleSomeObjects" and object having connectedTickets()

But can't find the way of listing all the "connected JIRA issues" of all these objects through a iql query in Confluence.

Is it possible?

Thanks in any case.

tokcum · Answer

Hi,

although this is a quite old thread, I would like to propose a solution. As @mazinger described he is looking for all issues which are linked to objects of a specific object type. The result should be presented in a Confluence page.

As mazinger is looking for issues, we have to use JQL in the first place and not IQL. With IQL we can only look for Insight objects. However, we need IQL to describe the objects we are looking for.

To work on a concrete example: in Jira we have an issue type Change and a custom field called "Configuration Items" which is of type Insight object. This field is configured to link to assets from a CMDB implemented in Insight. There are many object types such as Server, Client, Network or even Business Service in the CMDB. All those object types are considered to be CIs (Configuration Items).

Now we would like to list all unresolved Changes sorted by create date from latest to oldest which are linked to objects of object type "Server" and show that as a table in Confluence.

Here are the steps:

1. Install the Insight macro in Confluence (probably done already).

2. Find all objects we are interested in Insight by working on a IQL. We do not have to care about connected tickets in this step.

=> objectType = "Server"

3. Find all issues we would like to present by working on a JQL.

=> issueType = Change AND resolution IS EMPTY ORDER BY created DESC

4. Combine JQL with IQL through iqlFunction

issueType = Change AND "Configuration Items" IN iqlFunction("objectType = \"Server\"") AND resolution IS EMPTY ORDER BY created DESC

Cheers,

Tobias

P.S. I put the object type name in quotes and escaped them. This is not strictly necessary in this example because there is no space in this object type name. However, there could be spaces in the name so it is an example how to handle spaces as well.

Noor Christensen · Answer

This works perfectly, thank you. Example:

object having connectedTickets(project = TEST)

Stephen Letch_k2bocf · Answer

You probably don't even need the objecttype IQL. Try

object having connectedTickets(SomeJQLHere)