Table Parameter Expressions
TableParameter data functions allow you to build lookup functions by pulling data directly from Table Parameters. In the Expression Editor, use the Criteria helper panel to build your expressions:
Functions are available for each data type and the syntax is as follows, where Table is a specified table, TableParameter is a constant which is able to be re-evaluated at compile-time, and where N is the number of keys.
If there are no Keys in the Table Parameter, you don’t need to pass in any keys.
TableParameterDate(Table, TableParameter, Attribute, Key1, Key2,…,KeyN)
TableParameterDateSafe(Table, TableParameter, Attribute, SafeValue, Key1, Key2,…,KeyN)
TableParameterValue(Table, TableParameter, Attribute, Key1, Key2,…,KeyN)
TableParameterValueSafe(Table, TableParameter, Attribute, SafeValue, Key1, Key2,…,KeyN)
TableParameterText(Table, TableParameter, Attribute, Key1, Key2,…,KeyN)
TableParameterTextSafe(Table, TableParameter, Attribute, SafeValue, Key1, Key2,…,KeyN)
TableParameterBool(Table, TableParameter, Attribute, Key1, Key2,…,KeyN)
TableParameterBoolSafe(Table, TableParameter, Attribute, SafeValue, Key1, Key2,…,KeyN)
TableParameterInt(Table, TableParameter, Attribute, Key1, Key2,…,KeyN)
TableParameterIntSafe(Table, TableParameter, Attribute, SafeValue, Key1, Key2,…,KeyN)
TableParameterFloat(Table, TableParameter, Attribute, Key1, Key2,…,KeyN)
TableParameterFloatSafe(Table, TableParameter, Attribute, SafeValue, Key1, Key2,…,KeyN)
TableParameterRowIndex(Table, TableParameter, Attribute, Key1, Key2,…,KeyN)
TableParameterRowIndexSafe(Table, TableParameter, Attribute, SafeValue, Key1, Key2,…,KeyN)
The TableParameterRowIndex function returns the index of the matched row.
GetParameter
GetParameterValue and GetParameterRowIndex functions are similar to TableParameter functions except that they operate on the current table.
In the case of the GetParameterValue function, a TableParameterAttribute constant is able to be re-evaluated at compile-time. The return data type is resolved from the specified attribute.
The syntax is as follows, where N is the number of keys. If there are no Keys in the Table Parameter, you don’t need to pass in any keys. SafeValues are optional.
GetParameterValue(TableParameterAttribute, Key1, …, KeyN [, SafeValue])
In the Expression Editor, use the Options helper panel to build your expressions:
GetParameterRowIndex(TableParameter, Key1, …, KeyN [, SafeValue])
The GetParameterRowIndex function returns the index of the matched row. In the Expression Editor, use the Options helper panel to build your expressions:
