The method api.getItemActiveCalculationResults() has been deprecated in 14.0 version.
Deprecated Usage
Groovy
def priceGridId = 843
def pgis = api.find("PGI", Filter.equal("priceGridId", priceGridId))
pgis.each {
def results = api.getItemActiveCalculationResults(it.typedId)
def activeCost = results?.get("Cost")?.getAt("result")
// ...
}
QueryApi Usage
This particular QueryApi usage requires the hibernate compression to be turned off by setting property jsonBlobCompressionThreshold = -1 on the cluster which can be done by support team.
Groovy
def priceGridId = 843
def qapi = api.queryApi()
def t1 = qapi.tables().priceGridLineItems(priceGridId)
qapi.source(t1, [t1.id(), t1.activeCalculationResult("Cost").as("Cost")])
.stream {
it.each {
def activeCost = it.Cost
// ...
}
}