Grief with the switch node

[little_rich]

Hi,
I have some data feeding into the switch node which is in this format
msg.payload.rows[0].current_price
msg.payload.rows[0].ref_price
msg.payload.rows[0].quantity

I am trying to use the switch command to filter based on whether the current price is > the ref_price or not.
A pass is meant to go out the top output and I have the fail as an 'otherwise' to go out the other output.

From what I can tell the top parameter kind of has to be the msg.payload format

In the next part of the switch I have chosen the > symbol
Regarding the parameter to test against, it doesn't seem to matter what I choose the result is always the same. Pass or Fail, they both go out the top or the bottom output.
(in another use of the switch, I test for null or !=null and it works perfectly)

msg.payload.rows[0].old_price
msg.$
msg.0-9 (looking for a numeric I assume)
msg.abc looking for text but I thought maybe the numbers were seen as text
I have even tried {new_price} type commands.

Also have tried the 'stopping on first match' selector.

Can someone suggest what 'should be the correct method' as I am just trying all combinations and getting nowhere.

[janvda]

Can you share the input of the switch node using a debug node ?

It is working for me:

[{"id":"daede0a2.fd909","type":"tab","label":"Flow 2","disabled":false,"info":""},{"id":"5e7ed0c8.a823b","type":"inject","z":"daede0a2.fd909","name":"is greater","props":[{"p":"payload"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"{\"rows\":[{\"current_price\":100,\"ref_price\":80}]}","payloadType":"json","x":180,"y":100,"wires":[["6c2fdb3a.35bda4"]]},{"id":"6c2fdb3a.35bda4","type":"switch","z":"daede0a2.fd909","name":"current > ref","property":"payload.rows[0].current_price","propertyType":"msg","rules":[{"t":"gt","v":"payload.rows[0].ref_price","vt":"msg"},{"t":"else"}],"checkall":"false","repair":false,"outputs":2,"x":460,"y":140,"wires":[["593396f8.b68408"],["3e95ade6.793162"]]},{"id":"593396f8.b68408","type":"debug","z":"daede0a2.fd909","name":">","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":640,"y":80,"wires":[]},{"id":"3e95ade6.793162","type":"debug","z":"daede0a2.fd909","name":"otherwise","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":660,"y":160,"wires":[]},{"id":"869d1641.30c798","type":"inject","z":"daede0a2.fd909","name":"is smaller","props":[{"p":"payload"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"{\"rows\":[{\"current_price\":80,\"ref_price\":100}]}","payloadType":"json","x":180,"y":140,"wires":[["6c2fdb3a.35bda4"]]}]

[little_rich]

Thank you for having a look.
Does this help?
It is coming from a database query further back. But I was convinced by looking at the paths to the data that it should work.

[janvda]

You are comparing strings not numbers.
So, you should convert string to number.
This can also be done in switch node using jsonata expression:

The flow with updated switch node:

[{"id":"daede0a2.fd909","type":"tab","label":"Flow 2","disabled":false,"info":""},{"id":"5e7ed0c8.a823b","type":"inject","z":"daede0a2.fd909","name":"is greater","props":[{"p":"payload"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"{\"rows\":[{\"current_price\":\"100\",\"ref_price\":\"80\"}]}","payloadType":"json","x":180,"y":100,"wires":[["6c2fdb3a.35bda4"]]},{"id":"6c2fdb3a.35bda4","type":"switch","z":"daede0a2.fd909","name":"current > ref","property":"$number(payload.rows[0].current_price)","propertyType":"jsonata","rules":[{"t":"gt","v":"$number(payload.rows[0].ref_price)","vt":"jsonata"},{"t":"else"}],"checkall":"false","repair":false,"outputs":2,"x":460,"y":140,"wires":[["593396f8.b68408"],["3e95ade6.793162"]]},{"id":"593396f8.b68408","type":"debug","z":"daede0a2.fd909","name":">","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":640,"y":80,"wires":[]},{"id":"3e95ade6.793162","type":"debug","z":"daede0a2.fd909","name":"otherwise","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":660,"y":160,"wires":[]},{"id":"869d1641.30c798","type":"inject","z":"daede0a2.fd909","name":"is smaller","props":[{"p":"payload"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"{\"rows\":[{\"current_price\":\"80\",\"ref_price\":\"100\"}]}","payloadType":"json","x":180,"y":140,"wires":[["6c2fdb3a.35bda4"]]}]

[little_rich]

Oh gosh, thank you so much. I really should have asked on Saturday, I have spent hours on this.
I really appreciate your support.