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

Interface InputsColumns.InputColumns

All Superinterfaces:

Map<String,SelectableExpression>, Tables.Columns

All Known Subinterfaces:

ClicColumns.InputColumns

Enclosing interface:

InputsColumns

public static interface InputsColumns.InputColumns
extends Tables.Columns

The columns of one input of a row, as returned by InputsColumns.input(String).

It is also a map of column name to column, so the columns can be accessed as properties, for example t.input("Quantity").value.

Since:

15.0.6 - Southside

Nested Class Summary

Nested classes/interfaces inherited from interface Map

Map.Entry<K,V>

Method Summary

Modifier and Type	Method	Description
SelectableExpression	value()	Returns the value of the input.

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

Method Details

value

SelectableExpression value()

Returns the value of the input.

The value is always returned as text: numbers are converted to their string representation, and structured values such as maps or lists are returned as JSON. Use castAsReal(), castAsInteger() or a similar cast to compare the value with a number. Unless you set an alias with as(), the result column is named after the input, for example Quantity_value.

Example:

 def q = api.queryApi()
 def t = q.tables().quoteLineItems("P-1168")
 def qty = t.input("Quantity").value()

 return q.source(t, [t.lineId(), qty.as("Qty")], qty.castAsReal().greaterThan(100))
         .stream { it.collect { it } }
 

Returns:

the value column as a String expression (this string may contain json serialized data)