Package net.pricefx.service

package net.pricefx.service
Summary queries that aggregate the items of a Simulation.

A summary query groups the items of one or more objects by an item field, a product field, or both. It counts them, and aggregates fields, for example as a sum. Summary queries for price lists, price grids and Rebate Records are deprecated. Query those items with PublicGroovyAPI.queryApi() instead.

Entry point: PublicGroovyAPI.getSimulationSummaryQuery(). The query runs with api.runSummaryQuery().


 def query = api.getSimulationSummaryQuery()
 query.addObjectTypedId("12.SIM")
 query.setDoCount(true)
 query.addProjection("resultPrice", "SUM")
 def rows = api.runSummaryQuery(query)

Reference