TQL Script: Multiple Sinks in one script

[MJozw]

Hello All,
I've an MQTT Sensor which publishes mulitple information in one Topic, separated with semicolon.
To be able to store both information into a Tag based database I would need to call the INSERT command twice.

Something like this:

STRING(payload() ?? "+5.44;+3.9;", separator(";"), trimspace(true))
MAPVALUE(2,value(0))
MAPVALUE(1,time("now"))
MAPVALUE(0,"Temp. external")
INSERT("name", "time", "value",table("ams_0010"))

STRING(payload() ?? "+5.44;+3.9;", separator(";"), trimspace(true))
MAPVALUE(2,value(1))
MAPVALUE(1,time("now"))
MAPVALUE(0,"Temp. internal")
INSERT("name", "time", "value",table("ams_0010"))

One solution I already though about is to have two different subscriber with two different TQL Files, but is there also a solution with one subscriber and one tql file?

[OutOfBedlam]

use SCRIPT("js",...) and you can call insert statements as many as you want even into the different tables and bridged databases and http request to the external server.

then set the sink DISCARD() if you have done all you need in the SCRIPT and nothing to do with sink.