Lookup and get the value from an Insight object

Question

Hi,

I'm a beginner of using Jira and Insight.

I have an Insight Object Schema setup named "Hardware" and Object type "Staff" contains the attributes "Email" and "Computer".

When an issue is created, I would like the Automation to use the reporter's email address to lookup an object that matches with the Staff Email, then return the "Computer" value and edit an Insight Objects custom field of the issue.

What could be the correct syntax to run the lookup and edit the issue by using the Automation?

Thank you.

Iman Attia · Answer

Lookup objects: in automation via the hardware schema;

Query:

"Email" LIKE "{{issue.reporter.emailAddress}}" AND objectType in objectTypeAndChildren("Staff")

This will return the staff profile, you can then add use edit to add:

{{lookupObjects.Computer}} or something along these lines

Bill Sheboy · Answer

Perhaps try the advanced compare condition, referencing your object and check if it is non-null (not empty) before the edit.

Jason Chan · Answer

Hi Bill,

I've managed to lookup the insight object in the automation rule, now I want to add a component to check if the object can be found before editing the issue.

What condition should I use?

Thank you.