You don't need `nlobjSearchFilter` for a Filter Ex...
# suitescripte
erictgrubaugh
03/12/2020, 7:01 PMYou don't need
nlobjSearchFiltera
AB
03/12/2020, 7:15 PMHey @erictgrubaugh ,
Can you please let me know what I am doing wrong?
Below is the code
var columns = new nlobjSearchColumn('id');
var totalRecords = nlapiSearchRecord(null,'customsearch476',[['shortname','equalTo','Arizona'],'or',['fullname','equalTo','Arizona']],columns);
e
erictgrubaugh
03/12/2020, 7:22 PMHard to say without knowing exactly what's going wrong.
erictgrubaugh
03/12/2020, 7:22 PMSyntax looks fine.
a
AB
03/12/2020, 7:24 PMNow I am trying below code
var columns = new nlobjSearchColumn('id');
var totalRecords = nlapiSearchRecord(null,'customsearch476',[['shortname',null,'equalTo','Arizona'],'or',['fullname',null,'equalTo','Arizona']],columns);
And getting error message "Malformed search filter expression, first two elements must be strings."
e
erictgrubaugh
03/12/2020, 7:28 PMoh, you have too many elements in your filters; remove your `null`s
erictgrubaugh
03/12/2020, 7:29 PMA Filter Expression is only
[fieldId, operator, value][fieldId, operator, value1, value2]a
AB
03/12/2020, 7:31 PMThank you so much @erictgrubaugh
Now I got the result.
e
erictgrubaugh
03/12/2020, 7:33 PMnp
44 Views