8 Replies Latest reply: Jul 30, 2012 9:35 AM by Jason W RSS

Problems with OR statement in Class Mappings in Query

Jason W

I am running a simple OR statement as part of my CI Class Mappings but when I add the OR statement I am getting inconsistent results.

 

If I have one condition then I get the correct results.

 

ParentConfigItem = 'Blue'

 

if I have two conditions using an OR statement then I retrieve the zero rows

 

ParentConfigItem = 'Blue' OR ParentConfigItem = 'Black'

 

If I then try, in brackets

 

(ParentConfigItem = 'Blue' OR ParentConfigItem = 'Black' ) then I get the entire data set.

 

I need to run this query using seven variables using the OR statement, does anyone have any advice on how I can get the synatax to work?