How to use filter (where not in) in QV script

[#1]

this what we are using in sql scipting while generating qvd

AND THE.CallerID NOT IN (45,67,667,288)

but i wanted to apply this filter to qvd before reload.

can anyone help me.

thanks in advance.

[rbecher]

Hi,

you can probably use:

AND NOT Match(THE.CallerID, 45, 67, 667, 288)

- Ralf

[yavoro]

rather use it like this:  AND Match(THE.CallerID, 45, 67, 667, 288) = 0

[rbecher]

Same result but hard to read..

[yavoro]

Maybe this is the best option then (just found it):

AND NOT EXISTS (THE.CallerID,45,67,667,288)

Never used it myself, but will do next time I need something like that.

Regards