Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Looking for an option to iterate through Insight LookupObjects and do some checks

Hi all,

I have one specific requirement for which I am unable to find a way to fulfil, so wanted to share it with you and see if anyone has any idea or option that can help:

Environment: Jira SM Cloud , Insight CMDB, Automation for Jira, JMWE

In the Insight we have an Object "Contact" with different attributes, including "Email" containing Contact's email address.

Requirement: I am asked to create a scheduled automation rule that will be triggered once in a day and runs the following sequence:

  • gets all "Contact" objects - to get access to their Email addresses
  • for each value/Email in the lookupObjects."Email" result set I should check whether the "Contact" has a Customer Portal account created or not

Obstacles: My idea was within a Automation for Jira rule to get the "Contact" objects, iterate through their Email addresses and somehow compare whether there is a registered Customer user with that same email address.

However, I was unable to find available ways to do the following:

  • Insight IQL - was unable to find a way to iterate through the result set - for each value to do some actions/checks. I found the option to display the values in the Log, but not to do additional comparison
  • Within Jira Smart values I was unable to find a way to access the Portal Customers database - there are options to access issue Assignee/Reporter/Commenter or a value of a User Custom field, but not directly the Users list/database

I will appreciate if anyone of you can help with a suggestion or idea for some other approach?



1 answer

0 votes
Fabian Lim Community Leader Dec 28, 2021

Hi @Klime Buneski

You may want to use scriptrunner and have it perform these checks. Link:

Adding @Ravi Sagar _Sparxsys_ 

Thanks a lot @Fabian Lim ,

I will check the suggestion and will get back if any issues.



As I see, the articles are for the Server edition, while this instance is on Cloud.

Thanks again for the articles however.



Suggest an answer

Log in or Sign up to answer
Site Admin
Community showcase
Published in Jira Service Management

JSM Jira Automation: How to Send SLA Breached Notifications

Hi Everyone, In   this tutorial,  we will show you how you can monitor an SLA, and send notifications before or after the SLA has been breached.   SLA Threshold Trigger The SLA t...

801 views 5 13
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you