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