How to trigger alert when one row of list equals to zero

[thinhdinh]

Hi Experts,

I have a search query that give me a result table like below:

Employee	Salary
A	1000
B	2000
C	0

How can we trigger an alert when one of our employee's salary equals to zero or specific number?

[gcusello]

Hi @thinhdinh ,

you have to add a condition at the end of your search, e.g.

[gcusello · Accepted solution]

Sorry: wrong click!

you have to add a condition at the end of your search, e.g.:

| where Salary=0

and run an alert triggered when you have results.

Ciao.

Giuseppe