What's wrong with "where" ?

RouterOS Scripting
1

What am i doing wrong?

[lion@rb_bus_008] > ip firewall filter print where chain=input and action=drop                              
Flags: X - disabled, I - invalid, D - dynamic 
 0    chain=input action=drop protocol=tcp dst-port=8728 

 1    chain=input action=drop connection-state=invalid 

 2    chain=input action=drop 
[lion@rb_bus_008] > ip firewall filter print where chain=input and action=drop and protocol=tcp
Flags: X - disabled, I - invalid, D - dynamic 
[lion@rb_bus_008] >
2

Hmmm, this is a bug that MT should look at.
It seems that som field does work fine without quotes, but some not.

So this does not work

ip firewall filter print where chain=input and action=drop and protocol=tcp

But this work:

ip firewall filter print where chain=input and action=drop and protocol="tcp"

So to make sure it works, until MT fix this bug, quote everything

ip firewall filter print where chain="input" and action="drop" and protocol="tcp"

and seems to be optional, so this works as well

ip firewall filter print where chain="input" action="drop" protocol="tcp"
3

Thankyou, that really helps!

4

When you are trying to match a string, always use quotes. Console tries to guess the type of the variable, but sometimes it is not possible and you get unexpected result.