Using imbricated IQL queries for insight search

[Julien Laurent]

Hi all, 

I do use the Jira environment import in an Insight Object Schema. My end goal is to have a global view and allow me to do some cleanup.

To do such thing, I would like to be able to created imbricated IQL queries to display, for example, all the projects that are using some specific fields.

I can easily move from fields to project going one objectType at a time using inR and outR but that process is terribly pain full and I would like to have one query that will do it all for me.

I could not find a way to imbricate inR within other inR or ouR, something like that would work in my mind :

object having inR(object having inR("Key" IN (TJSOS-28466, TJSOS-28469, TJSOS-28471, TJSOS-28472, TJSOS-28498, TJSOS-28499)))

Sadly not in reality.

Is that possible at all ?

[Björn Gullander · Accepted solution]

Maybe something as easy as this :) (I couldn't help trying this query)

objectType=Project AND object HAVING outboundReferences(
  objecttype = "Issue Type Screen Scheme" AND object HAVING inboundReferences(
    objecttype = "Screen Scheme - Issue type" AND object HAVING outboundReferences(
      objecttype = "Screen Scheme" AND object HAVING inboundReferences(
       objecttype = "Screen - Issue Operation" AND object HAVING outboundReferences(
        objecttype = Screen AND object HAVING inboundReferences(
         objecttype = "Screen Tab" AND object HAVING inboundReferences(
          objecttype = "Screen Tab Field" AND "Field" = Approvers)))))))

It should give you the projects having the Approvers field on a screen connected to the project.

[Julien Laurent]

Perfect, just doing what I needed, thanks a lot.