Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

Recognition

  • Give kudos
  • My kudos

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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

Insight IQL comparing two attribute values

Hi,

 

I'm trying to set up an automation rule that sends alerts when an attribute integer value is set to a value less than that of another attribute. For example, item's "available stock" and "stock alert threshold", and whenever the value of "available stock" falls beneath the threshold value and e-mail will be sent.

 

The IQL ("available stock" <= "stock alert threshold") returns nothing, but if I write ("available stock" <= 10) the IQL works.

 

Could it be that Insight doesn't support comparing two attribute values?

 

Thanks!

Mohannad

1 answer

1 accepted

0 votes
Answer accepted

Hi Mohannad.

    The Automation Condition (IF) uses an IQL statement, which does not support placeholders to replace the Value of an Attribute.

I would like to recommend you to visit https://jira.riada.io which is our open ticket system for feature requests and verified bugs. You can view, watch, vote and comment on issues reported by anyone.

If you can't find an already opened ticket request for this feature, feel free to create a new one.

Your first query is trying to match an Attribute Value (in the Attribute "Available Stock") against the string "stock alert threshold" hence - it fails. (e.g. 7 <= "stock alert threshold" ), while your second statement is validating an Attribute Value against a Value; 7 <= 10 -->>>True

If placholders were supported in the IQL, the statement should have been "Available Stock") <= ${stock alert threshold}

//  ${...} is a placholder for the Attribute Value //

At the moment, a way to resolve this is by having an Automation Rule to run a Groovy Script Action which will compare the Attributes' Values - and, either run the expected Groovy script if the condition is True, or, as an example, set a Boolean Attribute as a Flag, for another Automation Rule to pick up resulting in a different Action (When Object Updated, If objectType = "yourObjectType" AND "Below Stock Threshold" IS True, then.....

Kind regards,

Yinon

Team Riada 

Hi Yinon,

If have a short, similar question, by comparing it attributes if same or not. By our SCCM import we have Top console user and Primary user, and I want to check by a automation if there containing same object or not.

Here you see, that the attribute not same

screen1.png

and here is the attribute same:

screen2.png

So what we want in the End, if Top console user is not same as Primary user to send an E-Mail, Create a ticket or whatever. I didnt could make any IQL which was resulting correct.

Thanks

Oli

Hi Oli. 

     For the case showing in your first screenshot - you can trigger an action with an IQL condition like:

("Top Console User" IS EMPTY AND "Primary User" IS NOT EMPTY) OR ("Top Console User" IS NOT EMPTY AND "Primary User" IS EMPTY)

However, if these two Attributes are NOT EMPTY (i.e populated) - then the only way available at the moment, to compare the two values, is by running a Groovy Script Action, which will also take care of sending an email / create a Ticket - if the Values do not match...

As noted here - there is currently no option, to compare two Attribute Values.

Cheers,

Yinon

Mindville support Team

Hi,

I'm new to groovy, and there is less documentation. Is there any documenation like a howto from scratch to work together with groovy and insight? The examples more confusing me on the documentation from insight :)

 

THanks

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Marketplace Apps & Integrations

5 mobile apps for Jira Cloud to boost productivity

  It’s very important to have access to the workflow process from anywhere. Especially if you manage the work of others. There is no difference whether you’re out of office, or drive a ca...

290 views 2 5
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