System fields

Some fields that are built into a BIRT report do not have corresponding IBM TRIRIGA business object fields.

The following table contains system fields with special names that have special meaning to the IBM TRIRIGA-BIRT integration.
Table 1. System fields
System field Usage Description
system__recordIds

Data set input parameter for business object data sets.

Report input parameter for form reports.

Comma-delimited list of record IDs that control the records that are returned from form reports. Required if you do not use the system_recordId input parameter.
system__recordId Data set input parameter for business object data sets. Numeric value that represents a single record to return from a business object data set. For a query report, this field is required. For a form report, this field is required if you do not use the system_recordIds input parameter.
system_parentRecordId

Data set input parameter for query data sets.

Data set input parameter for smart section data sets.

Report input parameter for query report.

Provides record context to reports and data sets.

For smart sections, system_parentRecordId is a required value that controls which record's section data to return.

For query data sets, the system_parentRecordId provides the $$RECORDID$$ and $$PARENT variables that are used in an IBM TRIRIGA query definition.

system__recordId Output column for all types of IBM TRIRIGA data sets. Every IBM TRIRIGA data set has an output column named system_recordId. The column contains the record ID of the returned record. The only case where this column is returned with a NULL value is for a non-pass through reference with modified smart section. In that case, there is no corresponding IBM TRIRIGA record.
system__sourceRecordId Data set output column for smart section data sets. Every smart section data set has an output column that is named system_sourceRecordId. The value holds the data that a smart section record was initialized from, which is called the source record. The system_sourceRecordId helps to differentiate the section record from the source record.