SOLVED Alert if 0 matches?

Help
1

I’m trying to use this. I’d like it to alert if zero matches. Right now it gets 1 match because the item exists.

if I do != it finds 550 matches because 550 rows are not equal to the string.

SELECT * FROM devices,processes WHERE (devices.device_id = 121 AND devices.device_id = processes.device_id) AND processes.command = “OpenSRF Listener [open-ils.circ]”;

image
image898×700 21.9 KB

2

nevermind,

I solved it using the “invert match” slider. I must be tired.