```function getCustomerPricing(customerId, integra...
# suitescript
m
Copy code
function 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;
}