Grab a Result for a specific SKU from a Live Price Grid

If you want to use calculation results of a specific SKU in a Live Price Grid (LPG) in another calculation:

  1. Run api.find() with type PGI

  2. A filter on SKU returns all Price Grid Items (lines in a price grid) for a given SKU.

1 def resultSet = api.find("PGI", Filter.equal("sku", mysku))

Note:

  • resultSet can return multiple lines if the SKU is present in multiple LPG’s.

  • The structure of resultSet[i] depends on the items of the LPG.

  • For the LPG of matrix type, use the type code XPGI.