So does this mean you have figured out how to connect to the database?
To compare data from two different places, you need to get the data into the same msg. In your case, you are sending data fron the RFID
mqtt-in node to the mssql node. Put a
debug node (set to displau the Complete msg object) on the output of both th e two nodes. Then you can see what the data looks like after exiting the
I imagine that the
mssql node will over write the msg.payload, so you will probably need to add a
change node, between the two nodes, to copy the original msg.payload to another msg variable. Then in the output of the
mssql node you should see all the information and be able to do what ever compares you need.