This topic applies only to the IBM Business Automation Workflow Advanced configuration.

QUERY_PROPERTY view

Use this predefined Business Process Choreographer database view for queries on process-level variables.

Table 1. Columns in the QUERY_PROPERTY view
Column name Type Comments
PIID ID The process instance ID.
VARIABLE_NAME String The name of the process-level variable.
NAME String The name of the query property.
NAMESPACE String The namespace of the query property.
GENERIC_VALUE String A string representation for property types that do not map to one of the defined types: STRING_VALUE, NUMBER_VALUE, DECIMAL_VALUE, or TIMESTAMP_VALUE.
STRING_VALUE String If a property type is mapped to a string type, this is the value of the string.
NUMBER_VALUE Integer If a property type is mapped to an integer type, this is the value of the integer.

If the property type is Boolean, the value is mapped to 0 (for false), or 1 (for true).
DECIMAL_VALUE Decimal If a property type is mapped to a floating point type, this is the value of the decimal.
TIMESTAMP_VALUE Timestamp If a property type is date, time, or timestamp, the value is mapped to a timestamp type, and this column contains the value of the timestamp.