SQL for finding SQLtags with "ACK MODE" set to "Auto"

Archived Topics
1

I’d like to find the tags set to ackmode = auto, and change them to ackmode = Manual.

Can you help me with this SQL. Thank you.

2

Here is a query to achieve that:SELECT * FROM sqlt_core s WHERE (SELECT COUNT(*) FROM sqlt_meta m WHERE m.tagid = s.id AND m.name = 'AlertMode' AND m.intval = 1) > 0 AND COALESCE((SELECT m.intval FROM sqlt_meta m WHERE m.tagid = s.id AND m.name = 'AlertAckMode'), 1) != 2;