QUERY_PROPERTY view: Business Process Choreographer database view

IBM BPM, V8.0.1, All platforms > Reference > Database views for Business Process Choreographer
QUERY_PROPERTY view

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

process instance ID.
Columns in the QUERY_PROPERTY view
Column name Type Comments
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.

Database views for Business Process Choreographer

Column name	Type	Comments
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.