Alerting by loki logs

Hi All,

I have a Spring boot microservices app. in Docker environment. I use Loki to processing logs. Docker containers log are redireced to syslog, and rsyslogd put every logs to different files. After that a Loki processing these files. When I explore Loki in Grafana I can define a query to get log messages contain SQLException pattern. After that I try to add an alert based on https://www.youtube.com/watch?v=GdgX46KwKqo . I copied the query and the graph said “no data”. But when I inspect the query there are results in it. My query is very simple:

{job=“infra”} |= “SQLException”

I want to get an alert, when there is SQLException line in a log file.

thx,
Zamek