Insight field data via a secondary JIRA project

[raymond Scott]

I have an Insight schema with an Object supporting Product data. I have another object supporting Product Groups. A Product can have 1 or more Product groups.

JIRA project XXX has an Issuetype "Initiative" and has 2 Insight custom fields Product and Product group

All the above works as expected, however...

Another JIRA project "YYY" wants to show the value of Product Group only. Project YYY has field called "Referenced Initiative", this is a link to Project XXX for the Initiative. However I need to use this Initiative key to fetch the corresponding Project XXX custom insight field "Product Group".

Eg JIRA Proj XXX

Key (Init-999) ,Product (ABC) ,Product Group (Group 1)

JIRA Project YYY

Key (Risk-123) ,Risk Summary (xxxx) ,Risk Initiative (Init-999)    Risk Product Group (group1)

I am unable to create a Scripted field that uses the Risk Initiative value, go to Project XXX and use the Risk Initiative to locate the Product Group and return it to the Risk Product Group.

I was hoping to use a Scripted field (Scriptrunner), but not sure if this is a possible solution or am i missing something more simple.