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?