Any insight on this. NI'm not used to adding formu...
# suitescriptj
Jack R
02/12/2023, 5:17 PMAny insight on this. NI'm not used to adding formula filters to a SS loaded from the UI.
Getting this error... "search.createFilter: Missing a required argument: name"... changing formulatext to name does not work.
Copy code
var searchObj = search.load({
id: 'customsearch_script_inventorybalance',
type: search.Type.INVENTORY_BALANCE
});
var defaultFilters = searchObj.filters;
var filters = []
if(itemType != '') {
filters.push(
{'formulatext':'{item.type}', 'operator':'is', 'values': itemType}
);
}
if (filters.length > 0) {
for (var i = 0; i < filters.length; i++) {
defaultFilters.push(filters[i]);
}
searchObj.filters = defaultFilters;
}a
Anthony OConnor
02/12/2023, 5:19 PMdoes the search you're loading already have formula text filters?
Anthony OConnor
02/12/2023, 5:20 PMI've seen it on columns where they get named with a number at the end so you can reference them.
formulatext1 formulatext2 etc... I think? its been a while, not something that comes up that often 😄
b
battk
02/12/2023, 5:31 PMthe objects you push into that filters array must match the parameters to search.createFilter
battk
02/12/2023, 5:32 PMas noted by the error, the name is required
a
Anthony OConnor
02/12/2023, 5:41 PM Copy code
filters.push({
name: 'formulatext'
operator: 'is'
values: itemType
formula: '{item.type}'
});Anthony OConnor
02/12/2023, 5:43 PMwhy do you have to use a formula for item type though? why not just a join to the type field on the item record?
b
battk
02/12/2023, 5:52 PMthat would require the use of the join parameter
a
Anthony OConnor
02/12/2023, 5:53 PMright...
Copy code
filters.push({
name: 'type'
operator: 'is'
values: itemType
join: 'item'
});4 Views