RE: Filtering on checkbox not working properly?
Hi, to try and make this short, I’m able to pull Expense Reports and filter with a custom checkbox no problem with the following code:
var myFilter = search.createFilter({
name: 'cust_sent_checkbox',
operator: search.Operator.IS,
values: ['false']
});
var results = search.create({
"type": search.Type.EXPENSE_REPORT,
"filters": [myFilter]
});
results = results.run();
return results.getRange(0, 1000);
Absolutely no problem with this. It returns all the Expense Report with the correct filter.
But, if i try with a standard checkbox like ‘Accounting Approval’ like this;
var myFilter = search.createFilter({
name: 'accountingapproval',
operator: search.Operator.IS,
values: ['false']
});
var results = search.create({
"type": search.Type.EXPENSE_REPORT,
"filters": [myFilter]
});
results = results.run();
return results.getRange(0, 1000);
Yet, I get the following error:
{
"errors": {},
"status": false,
"catch": {
"type": "error.SuiteScriptError",
"name": "SSS_INVALID_SRCH_FILTER",
"message": "An nlobjSearchFilter contains invalid search criteria: accountingapproval.",
"stack": [
"getRange(N/searchObject)",
"searchExpenseReport(/SuiteScripts/ExpenseReports.js:170)",
"onGet(/SuiteScripts/ExpenseReports.js:71)"
],
"cause": {
"type": "internal error",
"code": "SSS_INVALID_SRCH_FILTER",
"details": "An nlobjSearchFilter contains invalid search criteria: accountingapproval.",
"userEvent": null,
"stackTrace": [
"getRange(N/searchObject)",
"searchExpenseReport(/SuiteScripts/ExpenseReports.js:170)",
"onGet(/SuiteScripts/ExpenseReports.js:71)"
],
"notifyOff": false
},
"id": "",
"notifyOff": false,
"userFacing": false
}
}
Now based on NetSuite documentation here, accountingapproval is the correct internalID.
So, does anyone know what is it that I’m doing wrong?
Thanks!
I’ve only ever seen checkboxes filters with [`checkboxid’, ‘is’, ‘F’], perhaps try using ‘F’ or ‘T’ instead of true or false. Alternatively, make the search in the UI and use the chrome extension export saved search tool.
I really wish it was that simple. I tried all the possible values, true, false, T, F, quote or unquote, doesn’t make a difference, the problem remains the same.
I double down on the make the search in the ui, If you cant find accounting approval in the list of filters, its unlikely to be a filter you can add.
