0 Replies Latest reply: Sep 7, 2011 1:40 AM by Jeffrey Chan RSS

    Same field with multiple value in Search Query

      I use to have search Query for all "0" and null value data.

      But the data which i have now consist of 2 same field but different value which is 0 and 12


      ='=Amount<=0 or isnull(Amount)=-1'


      for example :


      Ticket Number      Amount

      12345                    0



      so what should i change my search query in order to fit the result where Ticket Number 12345's amount  is not consider as 0.