Insight referenced field: indirect referenced object (2-tier reference)

[Deleted user]

Is it possible to have a referenced field that is 2 links away? Say first single field says "Role": "Business Analyst". Now the Role is linked to "Project Roles" like eg. "Business Analyst (10300)" where 10300 is the project key. The user finally is linked to "Project Roles".

So how can I have a reference field that goes from "Role" to "User"?

[PJ Wysota · Accepted solution]

Well, there is a way:

1. You need to use Insight 5.4+ (older versions do not support it), and instead of referenced fields (although it might work with Referenced Fields, as I did not test that - since 5.4 I do not use Ref. Fields at all)

2. For outbound references You would use Issue Scope/Assign Scope with IQL syntax like:

ATTRIBUTE[OBJECT_REF] LEVEL1.ATTRIBUTE[OBJECT_REF] LEVEL2 = ${DEPENDENT_FIELD_VALUE}

- differentiating levels with "."

Example: 

"Assigned To"."JIRA User" = ${Reporter}

where Assigned to is referring to Insight User Object and JIRA User is attribute at that object.

3. For inbound references You would need usage of object having inboundReferences function

Examples:

a) inbound and outbound reference in the row

object having inboundReferences("Assigned To"."JIRA User" = ${Reporter})

b) 2 inbound references

object having inboundReferences(object having inboundReferences("JIRA User" = ${Reporter}))

Of course with more complex setups You would need more complex queries, e.g. adding differentiation of object types and using logical constructions AND/OR. 

[Deleted user]

Thanks, that is exactly what I needed! 

[Laurens Coppens]

Hi @[deleted]

This is not supported with referenced fields, you can't reference a referenced field.

I had a similar setup:

Insight field (field1)

referenced insight field (field2)

insight field with issue scope like this: (objecttype = "yourobjecttype" and  "attribute field1" = ${field1} and "attribute field2"= ${field2})

Is this what you need?

Regards,

Laurens

[Deleted user]

Hi @Laurens Coppens Thanks for your reply. That is close to what i need. @PJ Wysota was closer to the solution bc  I had inboundReferences (without realizing it).

Thanks anyway, I appreaciate your help!

Silvio