Hey Guys, I want to pass OR condition in one filte...
# suitescripta
AB
03/12/2020, 6:58 PMHey Guys, I want to pass OR condition in one filter, below is the code I am trying
var columns = new nlobjSearchColumn('id');
var filters = new nlobjSearchFilter([['shortname',null,'is','Arizona'],'OR',['fullname',null,'is','Arizona']]);
var totalRecords = nlapiSearchRecord(null,'customsearch476',filters,columns);
How can I do this?
b
battk
03/12/2020, 7:03 PMa
AB
03/12/2020, 7:09 PM@battk Below is the code
var columns = new nlobjSearchColumn('id');
var totalRecords = nlapiSearchRecord(null,'customsearch476',[['shortname',null,'equalTo','Arizona'],'or',['fullname',null,'equalTo','Arizona']],columns);
Can you please let me know what I am doing wrong?
b
battk
03/12/2020, 7:24 PMnot sure what you are searching, but you should probably be using
isbattk
03/12/2020, 7:24 PMnot
equaltoa
AB
03/12/2020, 7:31 PMThanks @battk, I got the result.
Thank You
4 Views