DSXchange

Hi,

Please tell me how to use Quality Manager to check this:

If the status is OPEN then the date column should be blank and
If the status is PENDING then the date column should also be blank and
If the status is CLOSE then there should be a date in the date column.

How do I create the data filter to specify the IF .. THEN.. ELSE?

Hi,

I think the filter should be like this

!(( status equals 'OPEN' AND
date not exists) OR
( status equals 'PENDING' AND
date not exists) OR
( status equals 'CLOSED' AND
date exists))

Regards, Alexandre