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

Interface QapiCustomerExtensionRow

All Superinterfaces:

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

public interface QapiCustomerExtensionRow
extends Tables.Table, PersistedObjectColumns

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

Example:

 def q = api.queryApi()
 def cx = q.tables().customerExtensionRows("SalesOrgData")

 return q.source(cx, [cx.customerId(), cx.SalesOrg, cx.Currency], cx.customerId().equal("CID-0003"))
         .stream { it.collect { it } }
 

Since:

14.0 - Caribou Lou

See Also:

• QapiCustomer
• Tables
• Customer Extension (CX#)

Nested Class Summary

Nested classes/interfaces inherited from interface Map

Map.Entry<K,V>

Method Summary

Modifier and Type	Method	Description
SelectableExpression	customerId()	Returns the ID of the customer 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

customerId

SelectableExpression customerId()

Returns the ID of the customer that the row holds data for.

Returns:

the customerId column as a String expression