Selection Pane Filter
This topic describes the different ways to use the selection pane filter.
This topic contains the following sections:
Filter in Bizview Data View
One way of filtering data that populates a dasharea is to add the selection pane variables in the actual Bizview data view connected to the dashareas.
In this example, the selection pane contains four different user controls that are then added to the data view. The control tag of each selection pane control are added as where clauses in the data view (e.g. @CLIENT, @PRODUCTID, and so on). To find the name of the selection pane control tags, access the Selection Pane Designer and open the selection pane.
Extract from dataview:
Caution: It is not possible to send NULL in a URL. For this reason, you cannot use NULL as a value ID in a drop-down list in a selection pane if the value should be sent into a dashboard(or report/form). Instead, you should use '' (empty string).
Dasharea Filter in Dashboard Design
Instead of adding a where clause with the control tag parameters in the actual data view, you can also use @<control tag ID> parameters in a dasharea filter.
First, you need to know the control tag IDs in the selection pane that you have connected to the dashboard. An easy way to get the control tag IDs (instead of navigating to the Selection Pane Designer) is to trace data for one dasharea in the dashboard.
Access the Dashboard and select Edit dashboard.
Then, select the dasharea you want to view the control tag IDs for. Upon selecting the dasharea, additional options display next to the area, as shown below.
Select the show bound data icon:
A Dataview tracing dialog displays, as shown below. Access the control tag IDs by selecting the Selection Pane Values tab:
The control tag IDs display:
Select X to close the dialog.
Then, with the dasharea still selected, access the Filters section in the right panel:
In the Advanced Filtering section, select the Edit icon:
Instead of adding an actual value for the filter, define a @<control tag ID> , like below:
Select Ok.
Don't forget to Save your changes!
When the user makes a selection in the selection pane, those values will be sent into these filters and added to the cached SQL that populates the dasharea with data. If several values are sent into the @-parameter, then Bizview will convert the query from a = value to a SQL in value.
To view how the values from the selection pane are added to the dasharea query, trace the bound data and go to the Cached SQL tab.
Caution: It is not possible to send NULL in a URL. For this reason, you cannot use NULL as a value ID in a drop-down list in a selection pane if the value should be sent into a dashboard(or report/form). Instead, you should use '' (empty string).