A predefined filter restricts the data returned by a query built from an information object using Information Object Query Builder. Set a column’s Filter property to Predefined to create a dynamic filter in a report design in BIRT Designer Professional.
Use Prompt Editor to specify the filter’s display control type and list of values. Do not provide a default value. You create a list of values by specifying the values or by typing an Actuate SQL query that retrieves the values. You can specify the filter values as well as the values displayed to the user. If you type a query, the query must meet the following requirements:
The query must retrieve one or two columns from an information object or map, for example:
SELECT DISTINCT custID, customName
FROM "MyInformationObject.iob"
ORDER BY 2
SELECT DISTINCT custID, customName
FROM "MyInformationObject.iob" ['CA']
ORDER BY 2
The query must not contain a WITH clause.
1 In the row for that filter, choose Prompt editor.
2 In Prompt editor, complete the following tasks:
In Show as, select the display control type. The choices available and appearance of the page depend on the display control type you select.
If you use a display control type other than Text box, you can specify a list of values for the user to choose by typing the values and, optionally, the display names, as shown in Figure 3‑16. Alternatively, you can select from a list of database values by choosing Select Values.
Figure 3‑16 Typing values and display names for a filter
If you select Combo box (editable), Dynamic list of values, and Auto suggest, a drop-down list appears after the user types the number of characters specified in Start Auto suggest after N character(s). The list contains values that begin with the characters the user typed. For example, if the user typed 'Atel and N=4, the list contains the value 'Atelier graphique'. In this case, the query that retrieves the values must select two columns, a value column and a display name column.
The query must retrieve one or two columns from an information object or map, for example:
