SuiteScript 2.0 Error: SSS_INVALID_SRCH_FILTER_EXPR_TYPE-CarlZeng
Issue: a search throw error SSS_INVALID_SRCH_FILTER_EXPR_TYPE Malformed search filter expression, first two elements must be strings. Sample code that
Issue: a search throw error SSS_INVALID_SRCH_FILTER_EXPR_TYPE
Malformed search filter expression, first two elements must be strings.
Sample code that causing error:
var strFormulaNumeric = ‘CASE {custrecord_abc_id}’; for (var i = 0; i < this.arrPriceTblId.length; i++) {
strFormulaNumeric += ' WHEN \\'' + this.arrPriceTblId\[i\] \+ '\\' THEN ' + (i + 1);
}
strFormulaNumeric += ' ELSE 0 END';
… var arrColumns = [];
…
arrColumns.push(search.createColumn({
name : 'formulanumeric',
formula : strFormulaNumeric,
sort : search.Sort.DESC
}));
… var strFormulaFilter = ‘formulanumeric:’ + strFormulaNumeric; var arrFilters = [
[ ‘isinactive’, ‘is’, ‘F’ ], ‘AND’,
[ strFormulaFilter,
search.Operator.GREATERTHAN, 0 ] ];
…
Solution:
var arrFilters = [
[ ‘isinactive’, ‘is’, ‘F’ ], ‘AND’,
[ String(strFormulaFilter),
search.Operator.GREATERTHAN, 0 ] ];
We convert strFormulaFilter to a string again in JS, that works great :)
Great Idea:
When we have formula in the column, we sort it well; it’s the best way to roll out data as specific reqirement; works perfect :-)
Thanks site:
Notes from:
My best guess is that the Rhino interpreter parses string concatenation expressions into different Java classes than string literals/variables. The NetSuite API then fails to consider those classes when validating that an argument is a javascript “string”.
https://www.flowinglink.com/suitescript-2-0-sss\_invalid\_srch\_filter\_expr\_type/
