6 Replies Latest reply on Sep 12, 2018 9:33 AM by WARRIOR

    How To Filter Web Service Search With Less (<) or Greater (>) than

    WARRIOR Apprentice

      Does anyone know how to perform internal web service search where a target field value is less than or greater than a desired value?


      The following is well documented:


      var AllPastDue = Search('Loans#',{

      Status: 'Paid'});


      This works when you need values equal to a desired value, but how do you handle cases where the needed results have to be greater than or less than.




      var AllPastDue = Search('Loans#',{

      Amount: 10000});


      Or where field value is null. E.G:

      var AllPastDue = Search('Loans#',{