I'm doing this saved search within a restlet funct...
# generalf
Fernando Batres
06/12/2025, 8:39 PMI'm doing this saved search within a restlet function getPurchaseHistoryByParent(context) {
// Destructure the parameters from the incoming object
const { parentId, startDate, endDate = null } = context;
// Build base search filters
const salesOrderSearchFilters = [
// Now 'parentId' is the number 1720557
['customer.parent', 'anyof', parentId],
'AND',
['mainline', 'is', 'F'],
'AND',
// Now 'startDate' is the date string
['datecreated', 'after', startDate]
];
// Add end date filter if provided
if (endDate) {
salesOrderSearchFilters.push('AND', ['datecreated', 'onorbefore', endDate]);
}
// Add remaining filters
salesOrderSearchFilters.push(
'AND',
['type', 'anyof', 'SalesOrd'],
'AND',
['taxline', 'is', 'F'],
'AND',
['shipping', 'is', 'F']
);
log.debug('salesOrderSearchFilters', salesOrderSearchFilters);
// Create search columns
const salesOrderSearchColDateCreated = search.createColumn({ name: 'datecreated' });
const salesOrderSearchColItem = search.createColumn({ name: 'item' });
const salesOrderSearchColDisplayName = search.createColumn({ name: 'custcol3' });
const salesOrderSearchColAmount = search.createColumn({ name: 'amount' });
// Create the search
const salesOrderSearch = search.create({
type: 'salesorder',
filters: salesOrderSearchFilters,
columns: [
salesOrderSearchColDateCreated,
salesOrderSearchColItem,
salesOrderSearchColDisplayName,
salesOrderSearchColAmount,
],
});
// Process results with pagination
const results = [];
const salesOrderSearchPagedData = salesOrderSearch.runPaged({ pageSize: 1000 });
for (let i = 0; i < salesOrderSearchPagedData.pageRanges.length; i++) {
const salesOrderSearchPage = salesOrderSearchPagedData.fetch({ index: i });
const pageResults = salesOrderSearchPage.data.map(result => {
const dateCreated = result.getValue(salesOrderSearchColDateCreated);
const item = result.getValue(salesOrderSearchColItem);
const displayName = result.getValue(salesOrderSearchColDisplayName);
const amount = result.getValue(salesOrderSearchColAmount);
return {
dateCreated: dateCreated ? String(dateCreated) : '',
item: item ? String(item) : '',
displayName: displayName ? String(displayName) : '',
amount: amount ? Number(amount) : 0
};
});
results.push(...pageResults);
}
return results;
}
how could I add the subaccounts names or id's to know whose have bought each thing ?