Jeremy Dean
10/20/2022, 3:46 PMbattk
10/20/2022, 3:49 PMJeremy Dean
10/20/2022, 4:14 PMduplicatePOSearch.filters.push(customerFilter);
log.debug('duplicatePOSearch filters', duplicatePOSearch.filters);
duplicatePOSearch.run().each(function (result) {
customerPOs.push({
soInternalId: result.id,
soDocNum: result.getValue('tranid'),
soPONum: result.getValue('otherrefnum').trim().toLowerCase(),
});
return true;
battk
10/20/2022, 4:22 PMbattk
10/20/2022, 4:23 PMSciuridae54696d
10/20/2022, 5:54 PMvar searchObj = search.load({
id: "customsearch_1",
});
var list = [];
var page;
var pagedData;
var additionalFilterExpression = [
["isinactive", "is", "F"],
"AND",
["subsidiary", "anyof", params.subsidiaries],
"AND",
["date", "before", searchDate],
];
if (params.department) {
additionalFilterExpression.push("AND");
additionalFilterExpression.push(["department", "is", params.department]);
}
if (params.class) {
additionalFilterExpression.push("AND");
additionalFilterExpression.push(["class", "is", params.class]);
}
if (params.location) {
additionalFilterExpression.push("AND");
additionalFilterExpression.push(["location", "is", params.location]);
}
searchObj.filterExpression = searchObj.filterExpression.concat(additionalFilterExpression);
pagedData = searchObj.runPaged({pageSize: 1000});
pagedData.pageRanges.forEach(function(pageRange) {
page = pagedData.fetch({index: pageRange.index});
page.data.forEach(function(row) {
list.push({
a:row.getValue('');
})
return true;
});
return true;
});
this is what I'll do, hope it helpsJeremy Dean
10/20/2022, 7:28 PM