Script Logic - *SELECT with OR
I need to define a variable with a select instruction, using OR to filter members based on a property, like this:
*SELECT(%EQUIP_TRGRDIST%,ID,AREA_NEGOCIO,"TIPO_EQUIP='03' OR TIPO_EQUIP='04'")
However, when I tried to execute this on UJKT transaction, I got an error saying "invalid select". Then I tried to replace the OR with an AND, just to check that there wasn't an error in the instruction (although it wouldn't get the results I wanted) and it worked perfectly.
This means that OR is not supported in the *SELECT instruction?
I know I can separate this in several *SELECT to obtain the results, just wanted to check if this is in fact true!