Another date question, this time lookupObects query

Question

Hi,

In an assets object I have Next Event (which is a date).  I have Event Notification (a number).

What I want to do is in a lookup objects return the events whose event date is within now and the event notification days.

So this works.

"Event date" < now(14d) and Status = "Active"

BUT the 14d isn't a constant and I need that to be whatever the value is in the attribute.

Is this possible?

Alex Koxaras -Relational- · Answer

Hi @Ste404

You need first of all to create an asset object field which will reference that specific object. Then you will be able to get its attribute and use smart values to add it to {{now}}.

Adolfo Casari · Answer

I believe you will have to do that using smartvalues in your rule. Just read all the objects (with status= Active) and filter out with those 2 parameters. See this:

https://community.atlassian.com/t5/Jira-Service-Management/Increase-number-of-months-based-on-a-smart-value/qaq-p/2756707