You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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
Microsoft Server 2013
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.
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)
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!