Package net.pricefx.formulaengine.scripting.queryapi.tables

Interface QapiPriceListLineItem

All Superinterfaces:

CalculableObjectLineItemColumns, Map<String,SelectableExpression>, PersistedObjectColumns, PriceCalculableObjectLineItemColumns, Tables.Columns, Tables.Table

public interface QapiPriceListLineItem
extends Tables.Table, PersistedObjectColumns, PriceCalculableObjectLineItemColumns

Table of the items of one Price List. Each row is one item, identified by its Stock Keeping Unit (SKU) and, in a matrix Price List, by key2().

Example, the items whose calculation raised a critical alert:

 def q = api.queryApi()
 def t = q.tables().priceListLineItems(841)

 return q.source(t, [t.sku(), t.resultPrice(), t.previousPrice(), t.priceChangePct()], t.hasCriticalAlert().isTrue())
         .stream { it.collect { it } }
 

Since:

14.0 - Caribou Lou

See Also:

• QapiPriceList
• Tables
• Price List Item (PLI)

Nested Class Summary

Nested classes/interfaces inherited from interface Map

Map.Entry<K,V>

Method Summary

Modifier and Type	Method	Description
SelectableExpression	hasCriticalAlert()	Returns whether the logic raised a critical alert when it calculated the item.
SelectableExpression	key2()	Returns the value of the second dimension of the item, in addition to the product.

Methods inherited from interface CalculableObjectLineItemColumns

alerts, allowedOverrides, calculationResult, comments, completeCalculationResults, completeResultsAvailable, dirty, itemExtensions, label, manualOverrides, tainted, warnings, workStatus

Methods inherited from interface Map

clear, compute, computeIfAbsent, computeIfPresent, containsKey, containsValue, entrySet, equals, forEach, get, getOrDefault, hashCode, isEmpty, keySet, merge, put, putAll, putIfAbsent, remove, remove, replace, replace, replaceAll, size, values

Methods inherited from interface PersistedObjectColumns

createDate, createdBy, id, lastUpdateBy, lastUpdateDate, version

Methods inherited from interface PriceCalculableObjectLineItemColumns

calculatedResultPrice, currency, manualResultPrice, previousPrice, priceChange, priceChangePct, resultPrice, sku, unitOfMeasure

Method Details

key2

SelectableExpression key2()

Returns the value of the second dimension of the item, in addition to the product.

Only available when the Price List is a matrix Price List; on other Price Lists, calling this method fails with an error.

Returns:

the key2 column as an expression (its type will be taken from the corresponding attribute meta configuration if it exists)

See Also:

• QapiPriceList.pricelistType()

hasCriticalAlert

SelectableExpression hasCriticalAlert()

Returns whether the logic raised a critical alert when it calculated the item.

A Price List that has an item with a critical alert cannot be submitted for approval, unless the partition allows it.

Returns:

the hasCriticalAlert column as a Boolean expression

See Also:

• CalculableObjectLineItemColumns.alerts()