If you want to use calculation results of a specific SKU in a Live Price Grid (LPG) in another calculation:
-
Run
api.find()with type PGI. -
A filter on SKU returns all Price Grid Items (lines in a price grid) for a given SKU.
Groovy
def resultSet = api.find("PGI", Filter.equal("sku", mysku))
Note:
-
resultSetcan return multiple lines if the SKU is present in multiple LPGs. -
The structure of
resultSet[i]depends on the items of the LPG. -
For the LPG of matrix type, use the type code XPGI.