Grab Result for Specific SKU from LPG
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.
def resultSet = api.find("PGI", Filter.equal("sku", mysku))
Note:
resultSet
can 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.
Looking for labels? They can now be found in the details panel on the floating action bar.
Related content
Trigger Partial Live Price Grid Calculation from Calculation Flow
Trigger Partial Live Price Grid Calculation from Calculation Flow
Read with this
Create a Custom Mass Action
Create a Custom Mass Action
Read with this
General Queries (Quick Reference)
General Queries (Quick Reference)
More like this
Matrix Price List Lookup
Matrix Price List Lookup
More like this
How to Configure Dashboards with Result Matrix Click Events
How to Configure Dashboards with Result Matrix Click Events
More like this
api.getPricelistItem()
api.getPricelistItem()
More like this
Found an issue in documentation? Write to us.