Query -- Notification if failed

1

Hello,
i create a new Postgres Database connection. In This DB there is a table which contains information for some Backups. The Table “Backup” contains a Success 1 or 0 and write every hour one row.
So far all is working.

Now i want to make an notification in Grafana, when is now row last1-2h or the row contains 0 instead 1, then should send an notifications. But this is not working. How can i resolve this ?

kairos3
kairos31377×670 101 KB
kairos2
kairos21455×732 128 KB

2

kairos1
kairos11003×320 170 KB

3
  1. If you try the Test Rule button, what does the result look like? This tests if the query is working.
  2. Have you set up a notification channel to send the notifications to and have you configured it for the alert?

Also, should note that you have a For 5m condition which means that it has to trigger for 5 minutes before sending a notification.