/
Grab Result for Specific SKU from LPG

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:

  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.

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.

 

Related content

Live Price Grid Detail
Live Price Grid Detail
Read with this
Matrix Price List Lookup
Matrix Price List Lookup
More like this
Make Price List/Grid Column Editable
Make Price List/Grid Column Editable
Read with this
How to Configure Dashboards with Result Matrix Click Events
How to Configure Dashboards with Result Matrix Click Events
More like this
General Queries (Quick Reference)
General Queries (Quick Reference)
More like this

Found an issue in documentation? Write to us.