This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hello, what am I doing wrong with my search filters below?  I keep on getting an error when I try to save my script.   filters: [{
              name: 'name',
              operator: <http://search.Operator.IS|search.Operator.IS>,
              values: [ratiodate]
              },"AND",{name: 'trandate',
              operator: search.Operator.WITHIN,
              values: [custrecord_pi_startdate,custrecord_pi_enddate]}
              });

how do I add a condition to support both filters?

use a <https://system.netsuite.com/app/help/helpcenter.nl?fid=section_458440490721.html|filter expression>

you shall receive the generic search advice to build the search in the ui, load it in script, then copy it

Hello, I have one more question.  Is it possible to do a within statement  for a search filter in a script with two custom fields?   filters[1] = search.createFilter({ name:'trandate',operator: search.Operator.WITHIN,values: [custrecord_pi_startdate,custrecord_pi_enddate] });

I can not figure out how to set that up in a saved search

same answer as last time you asked, use 2 filters