Send a notification to Slack when issue field have the appropriate date and time

[Sebastian]

Hello community,

I want to create an automate, which send to slack information about maintenance work in our company.

We have a field named: "Start of works" and this field is Date Time Picker with date and time.

I want to refer to this field, and try to do it like this jql :

start of works=now()

but it seems not working , because when the time from this field is appropriate the jql function nothing returns,

If there are any other solutions to integrate this ?

[Sebastian]

any update?

[Kseniia Trushnikova]

Hi @Sebastian,

Use this JQL instead:

"Start of works" > startOfDay() and "Start of works" < endOfDay() 

It will return all issues with the current date in this field. 

[Sebastian]

@Kseniia Trushnikovayes I know about it, but I want to refer to certain value date and time with this field, for example:

date and time from filed is: 07/09/2023 12:22

and when system date and time is the same – send notification,

[Kseniia Trushnikova]

@Sebastian, I don't think that's possible. I guess that would only be possible if a rule could be scheduled to run every minute to check the field, but rules cannot be scheduled at intervals less than 5 minutes.

You can try to create this rule:

1. Trigger: Scheduled every 5 minutes.
2. Condition: JQL "Start of works" > now() and "Start of works" <= 5m
3. Action: Send Slack message.

This rule will notify of issues where the field value is less than the next 5 minutes.

[Sebastian]

not work properly, because jql not finding issues