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

Interface QapiProductExtensionRow

All Superinterfaces:

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

public interface QapiProductExtensionRow
extends Tables.Table, PersistedObjectColumns

Table of the rows of one Product Extension (PX) table. Each row holds additional data for one product, typically values that depend on another dimension such as time or sales organization.

Example, the costs of the current product that are valid today:

 def q = api.queryApi()
 def exprs = q.exprs()
 def px = q.tables().productExtensionRows("Costs")
 def date = new Date()

 return q.source(px, [px.sku(), px.SalesOrg, px.Cost, px.Currency],
         exprs.and(px.sku().equal(api.currentItem("sku")), px.ValidFrom.lessOrEqual(date),
                 px.ValidTo.greaterOrEqual(date)))
         .stream { it.collect { it } }
 

Since:

14.0 - Caribou Lou

See Also:

• QapiProduct
• Tables
• Product Extension (PX#)

Nested Class Summary

Nested classes/interfaces inherited from interface Map

Map.Entry<K,V>

Method Summary

Modifier and Type	Method	Description
SelectableExpression	sku()	Returns the Stock Keeping Unit (SKU) of the product that the row holds data for.

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

Method Details

sku

SelectableExpression sku()

Returns the Stock Keeping Unit (SKU) of the product that the row holds data for.

Returns:

the sku column as a String expression