Hi,
does anyone see a way to optimize one condition away without changing
the SQL ?
condition = ${if !eq{TXTA}{${lookup mysql {SELECT --SQL-- }}} {1}}
condition = ${if !eq{TXTB}{${lookup mysql {SELECT --SQL-- }}} {1}}
Note: both SQL call exactly the same.
would this be possible, it would help
set acl_m9 = ${lookup mysql {SELECT --SQL-- }}
condition = ${if !eq{TXTA}{$acl_m9} {1}}
condition = ${if !eq{TXTB}{$acl_m9} {1}}
Also an option would be something like this : any REGEX available at
that point?
condition = ${if !Regexp{(TXTA|TXTB)}{ SQL } {1}}
best regards,
Marius