Trigger when something new enters a filter

[Miguel Silveira]

Is there any way to create a rule in automation that triggers when something new appears in a certain filter? 

I'm calculating dates and time passed since the issue creation until the due date, calculating half the time reached and 75% time reached. When something gets in the filter of the 75% for example, i want to be able to edit certain parameters and notify the assignee of the issue.

At the moment it is a scheduled rule with a conditions that verifies if the issue is at the 75% due date reached and then edits the parameter. I thought the box of "Only include issues that have changed since the last time this rule executed" would be for "something new appeared on the filter" but then i realized that this check is for updated issues, so, it only changed the field that i wanted if the issue was updated. Since we're talking about dates and times, there's no point on waiting for an update.

Is there even a workaround or this is not even implemented in any way?

Best Regards,
Miguel

[Brydie McCoy (CB) · Accepted solution]

Hi Miguel,

You are right that the checkbox does not make sense in your case when you are waiting for a certain date to be reached!

However, I'm still a little unsure of your setup.  Is the problem that the rule executes multiple times on issues after they have reached 75% or that issues are being picked up before they reach 75%?

A screenshot of your existing setup would also help.  It might be easier if you raise a Support Request with us and we can go through your specific scenario and see if we can find a solution that works.

Cheers,
Brydie

[Miguel Silveira]

Hello @Brydie McCoy (CB) 

I'm using sql, so the setup is a little complex.
My question is, is there a way of, let's say notify a user, each time an issue gets in these filters, not a subscription (that notifies all the issues in the filter everyday). I wanna get notified only once, each time a issue change its status, without needing an update (only the date changes).

[Brydie McCoy (CB)]

Hi Miguel,

You might be able to achieve what you are after by marking issues that the rule has already seen.

When the rule sees an issue it would send the notification.  And then also add e.g. a label "notification-sent" or you could use another custom field.  

You can set the JQL for the scheduled trigger to the JQL you are using for your 75% filter plus "AND labels not in ('notification-sent')" to exclude any you have already sent the notifications too.

The rule would run e.g. daily and would not have that checkbox checked.

Cheers,
Brydie

[Miguel Silveira]

Hello again @Brydie McCoy (CB)

My workaround was close to that solution. In fact i wanted to avoid flags of any kind, but since i needed something i just inserted a log or a comment that would say "50% reached on {{now}}" for example. If it finds " LIKE '50% reached'  "  and passes the 75% mark, it sends a notification and changes that value to "75%reached on {{now}}", else - ignore.
And so on and so on.

This is the same idea that you had, but added some utility to my problem, it's not great, but it's not awful either :b

Thank you for your help!

Best Regards,
Miguel