michoel
12/13/2019, 4:20 AMfunction getCustomerPricing(customerId, integrationId) {
const search = query.create({ type: query.Type.CUSTOMER });
const itemPricing = search.autoJoin({ fieldId: 'itempricing' });
const item = itemPricing.joinTo({ fieldId: 'item', target: 'item' });
const integrationItem = item.joinFrom({
fieldId: 'custrecord_mos_wi_item',
source: 'customrecord_mos_wi_integration_item',
});
search.columns = [
item.createColumn({ fieldId: 'id' }),
item.createColumn({ fieldId: 'itemid' }),
itemPricing.createColumn({ fieldId: 'price' }),
];
search.condition = search.and(
search.createCondition({
fieldId: 'id',
operator: query.Operator.EQUAL,
values: customerId,
}),
integrationItem.createCondition({
fieldId: 'custrecord_mos_wi_integration',
operator: query.Operator.ANY_OF,
values: integrationId,
})
);
const results = {};
search.run().results.forEach(result => {
const id = result.values[0];
const sku = result.values[1];
const price = result.values[2];
results[id] = { sku, price };
});
return results;
}