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

    Problems with OR statement in Class Mappings in Query

      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?