Hi Guys,
I am passing array in filters but getting...
# suitescripta
AB
11/15/2023, 9:07 PMHi Guys,
I am passing array in filters but getting "Filter expecting numeric value was removed, as non-numeric value" error? Below is the code,
var customerInternalIds = [];
var customerId = getSearchResult[i].getValue({name:'internalid'});
customerInternalIds.push(customerId);
filters.push(search.createFilter({
name: 'name',
operator: search.Operator.ANYOF,
values: customerInternalIds
}));
Can someone help me on this?
Thanks!
b
battk
11/15/2023, 9:09 PMsadly suitescript 1 has the best documentation on this
battk
11/15/2023, 9:09 PMgo lookup the section named
Copy code
SuiteScript 1.0 Supported Search Operators,
Summary Types, and Date Filterse
erictgrubaugh
11/15/2023, 9:10 PMThat error is very unhelpful, but just looking at the code,
nameANYOFa
AB
11/15/2023, 9:17 PM@battk/ @erictgrubaugh so which operator should I use?
BTW, this code is working on Sandbox but not working on Production, not sure why
b
battk
11/15/2023, 9:29 PMnot really enough code was shared
battk
11/15/2023, 9:29 PMbut there are really only 2 places you could get this wrong
battk
11/15/2023, 9:30 PMfirst is that name isnt a select or multi select type field, in which case the any of operator is invalid
battk
11/15/2023, 9:30 PMor that it is a select and your code messed up with the customerInternalIds
battk
11/15/2023, 9:31 PMone of them isnt an internal id
a
AB
11/15/2023, 9:34 PMOkay @battk, thanks!, will check it
6 Views