Parameters

In IBM TRIRIGA, queries have parameters that filter the data that is returned. In the Report Manager, you use user filters to configure query filters.

If a BIRT data set uses an IBM TRIRIGA query and that query has user input filters, each filter is shown in a starter report. The filters are shown in the Data Explorer tab as a top-level entry in the Report Parameters folder. This report parameter defines the user prompt that occurs prior to the report execution. The filters also are shown in the Parameters section as a parameter of the data set that models the IBM TRIRIGA query. The entry passes the report parameter value that you specify to the data set.

When a filter is required, the user filter in the IBM TRIRIGA query appears as a user prompt and filters the results based on the IBM TRIRIGA query definition.

The default label for a field is the business object field's label. You can add a custom label and help text for these report parameters.

If a report has multiple user filters on the same field, all filters are shown in the report. BIRT identifies parameters by using a suffix that corresponds to their positions in the query.

BIRT provides no means to differentiate between a filter to ignore and a NULL filter value. If you select NULL for a report parameter that maps to an IBM TRIRIGA query filter, the filter is not used.

For parameter types that are text, you can specify a value of NULL, and the IBM TRIRIGA query engine uses NULL as the filter value.

When a Boolean field is used in the user filter, the only accepted parameter values for the query engine to filter results are TRUE and FALSE (not case-sensitive). This requirement applies to users in US English and other languages supported by IBM TRIRIGA.

The IBM TRIRIGA BIRT integration processes the Time parameter filter correctly only when you use a String data type for the Time parameter. If you use a Time data type for the Time parameter filter, the TRIRIGA® BIRT viewer does not display an error, but it does not filter the results properly.

The IBM TRIRIGA BIRT integration processes non-English date and date time formats on the Date and Date Time filter parameters only if they are set as a String data type.