I recently had the need to create a quick custom filter for "NOT IN" and I thought it would be really easy considering the "IN" filter already exists, but I ended up having to specify
$CURRENT_FIELD NOT IN (${})
as my rule with the optional "suppress leading <field> placeholder" checked. The resulting rule preview is "SELECT * FROM <table> WHERE <field> NOT IN ([arg])" in either case, but without suppressing the leading <field> placeholder, it kicks back a SQL error. Specifically it gives me
MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN (1,2,3,7) LIMIT 0,1000' at line 1
Any idea why it would work in the one case but not the other?