Trying to load records that have fieldname "CHNG_ORD_SEQ"=1 and fieldname "CHNG_ORD_BATCH"=0, and CHNG_ORD_SEQ=0 and CHNG_ORD_BATCH=1, and anything with either field >0
Only want to eliminate records with zero in both fields.
I have written the code below, but it eliminates any record with a 0 in either field. Any ideas on why the AND is being ignored?
where (OPRID_MODIFIED_BY <> 'POCHNG')
and ("CHNG_ORD_SEQ"<>'0') and ("CHNG_ORD_BATCH"<>'0');
Try to handle the zero as numeric, no ' ' around the 0.
where (OPRID_MODIFIED_BY <> 'POCHNG') and ("CHNG_ORD_SEQ"<>0) and ("CHNG_ORD_BATCH"<>0);
It feels like there is something with your scenario that is not taken into consideration. Har to pinpoint without the actual application at hands.
You could give this a try
(OPRID_MODIFIED_BY <> 'POCHNG')
The best way to sort this out to load all the data (or a limited load of some number of rows). Put the Fields as Dimensions in a straight table and the where clause (everything but "where") as expression. See what it returns and play with it until you get -1 for the rows you want and 0 for the rows you don't.