Query Jira on Insight Reference fields

[Kathy Barton]

I set up an object that has a couple of reference fields. I want to query Jira to see all of the tickets that contain an object that has a specific value in one of those reference fields but I can't figure out the JQL. 

Example:
Object = Report

Reference field = LoB

In my head, it's something like this:
Report.LoB = Dental 

But that doesn't work. What is the JQL for Insight reference fields? 

TIA!

-Kathy

[Rickard Hyllenstam · Accepted solution]

Hi Kathy, 

You should use the iqlFunction to query Insight objects from JQL. 

So JQL looks like this:

customField in iqlFunction("Customer.\"Account Manager\" = \"Mathias Edblom\"")

Inside the iqlFunction you provide an IQL (Insight query language), here you check if an object has a certain value for the referenced attribute. 

Documentation is found here: https://documentation.riada.se/insight/latest/insight-user-s-guide/insight-jql-functions

Br,

Rickard

[Kathy Barton]

Thx! I found that documentation eventually and got it working.