Customizing the Browse Data List
To provide a customized list of values to users who select the 'Browse Data' option in a condition, specify a customized query. To do this, follow the steps below:
1. Click inside the 'Browse Data' column corresponding to the desired attribute. This opens a mini-toolbar in that cell.

2. Click the 'Select custom query' button. This opens the 'Select Custom Query' dialog box.

3. Select the desired query.
The first column of this query should return the desired attribute values, i.e., the values that will actually be sent to the database when filtering the data. The second column of the query should contain the corresponding labels, i.e., the text that will be shown to users in the 'Browse Data' menu. Query parameters, if required, can be specified as HTTP session attributes. (See Session-Based Single Sign-On in Integration for additional information). If a required query parameter is not specified, the corresponding condition is dropped.
4. Click 'OK' to close the 'Select Custom Query' dialog box.
5. Click the 'Apply' button in the mini-toolbar (or simply click away) to finalize the settings.
The selected query will now be used to supply the list of values that appears in the 'Browse Data' list for the corresponding attribute.
| << Sorting and Filtering a Physical View | © 1996-2013 InetSoft Technology Corporation (v11.5) | Defining Expression Attributes >> |