Open exx22 opened 11 months ago
Hi,
Is it possible to create a SQL query against the MySQL database so that two queries are executed on one click? I tried :
[ { "rawSql" : "INSERT INTO REPORTER.REPORTER_JOURNAL (chrono, userid, servername, serial, serverserial, text1) VALUES (NOW(), '${user.id}', 'GRAFANA', '$serverserial', '$serverserial', 'Alert Acknowledge by ${user.login}')", "format": "table" }, { "rawSql" : "UPDATE REPORTER.REPORTER_STATUS SET acknowledged = IF('${__user.login}' IN ('xxx', 'yyy'), '1', acknowledged) WHERE serverserial = '$serverserial'", "format": "table" } ]
Br, M
Hi,
Is it possible to create a SQL query against the MySQL database so that two queries are executed on one click? I tried :
[ { "rawSql" : "INSERT INTO REPORTER.REPORTER_JOURNAL (chrono, userid, servername, serial, serverserial, text1) VALUES (NOW(), '${user.id}', 'GRAFANA', '$serverserial', '$serverserial', 'Alert Acknowledge by ${user.login}')", "format": "table" }, { "rawSql" : "UPDATE REPORTER.REPORTER_STATUS SET acknowledged = IF('${__user.login}' IN ('xxx', 'yyy'), '1', acknowledged) WHERE serverserial = '$serverserial'", "format": "table" } ]
Br, M