The method api.getItemCompleteCalculationResults() has been deprecated in 14.0 version.
Deprecated Usage
Groovy
def pricelistId = 841
def plis = api.find("PLI", Filter.equal("pricelistId", pricelistId))
plis.collect {
def results = api.getItemCompleteCalculationResults(it.typedId)
def cost = results?.get("Cost")?.getAt("result")
// ...
}
QueryApi Usage
This particular QueryApi usage requires the hibernate compression to be turned off by setting the propertyjsonBlobCompressionThreshold = -1 on the cluster. This action can be performed only by support team.
Groovy
def pricelistId = 841
def qapi = api.queryApi()
def t1 = qapi.tables().priceListLineItems(pricelistId)
qapi.source(t1, [t1.calculationResult("Cost").as("Cost")])
.stream {
it.each {
def cost = it.Cost
// ...
}
}
See Also