api.getPricelistSummaryQuery()
The method api.getPricelistSummaryQuery() has been deprecated in 14.0 version.
Deprecated Usage
def plId = "929.PL"
def q = api.getPricelistSummaryQuery()
q.addObjectTypedId(plId)
q.setDoCount(true)
q.setItemGroupBy("attribute1")
q.setProductGroupBy("attribute3")
q.addProjection("Cost", "SUM")
def rows = api.runSummaryQuery(q)QueryApi Usage
def plId = 929
def qapi = api.queryApi()
def exprs = qapi.exprs()
def t1 = qapi.tables().priceListLineItems(plId)
def t2 = qapi.tables().products()
def rows = qapi.source(t1, [t1.sku, t1.SalesOrg, t1.Cost])
.leftOuterJoin(t2, { cols -> [t2.ProductGroup] }, { cols -> t2.sku().equal(cols.sku) })
.aggregateBy({ cols -> [cols.SalesOrg, cols.ProductGroup] }, { cols ->
[
cols.SalesOrg,
cols.ProductGroup,
exprs.sum(cols.RevenueImpact).as("RevenueImpact"),
exprs.count().as("Count")
]
})
.stream { it.collect { it } }See Also
Found an issue in documentation? Write to us.