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

unknown

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

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.