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

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,463,742
Community Members
 
Community Events
176
Community Groups

Automation on attribute date (Insight Cloud)

Edited

Hello, I am new to JIRA Insight (Cloud) and am trying to set up an automation on an Object Type. Basically I have set up a Software Asset Management schema, the Object Type is named Software Application and I created a list of Objects with Attributes. One of the Attributes is called Licence Expiration Date and the type is Date. 

So it looks like this. 

Schema: Software Asset Management

Object Type: Software Application

Object:  Adobe Pro DC

              Symantec

              Microsoft Server 2013

              Filezilla

              Etc.

Attribute: Licence Expiry Date (type Date)

I am trying to set up an Automation that lists all Objects of which the Licence Expiration Date is 30 days or less from the date value. 

The schedule is set to run daily at 9am. 

The Lookup Object query is: objectType = "Software Application" and "Licence Expiration Date" < endOfMonth(-30d)

Then the action is to send en email listing all Objects that will expiry 30 days or less from the value set in the Attribute field. 

When I run the Automation it finds 0 objects, although one of the Licence Expiry Date is set for 2 Sep 2021 as a test.

I suspect the Query is wrong, so I appreciate some feedback on how to set this up. 

Thanks in advance. 

 

1 answer

1 accepted

1 vote
Answer accepted

Hi,

Could you please run the IQL in the Object Type screen in the advanced search menu? Do you see any results?

Instead of -30 try using 30 like:

objectType = "Software Application" and "Licence Expiration Date" < endOfMonth(30d)

Cheers

Hakan Bahadir

Solutions Engineer

Hahaha, that fixed it. Just one little character. Anyway, it found the one object that it was supposed to find. Now I need to configure my email so it has all the right information. 

Like Hakan Bahadir likes this

Where can I find the Global Rules?

Tried that but doesn't seem to direct me to the Global Rules, when I try to create a new rule

For this automation rule did you all use an IQL Condition after a Schedule Trigger? For some reason the IQL syntax box is greyed out for me when I attempt this, so I cannot use an IQL query as a condition. 

What am I missing here? 

Do I need to use the Issue Field tab? Why is the Object tab unusable here?

Edit: Nevermind, I see that you have to use an IQL branch not an IQL condition!

Like Dang Tran likes this

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events