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.

       

      E.G:

       

      var AllPastDue = Search('Loans#',{

      Amount: 10000});

       

      Or where field value is null. E.G:

      var AllPastDue = Search('Loans#',{

      !ChargeBack});