Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

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:

dataviewfilter

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.

  1. Click the Selection pane values tab, and the control tag IDs will be shown:

selpaneControlTags

  1. Then, go to the Filters section in dasharea settings and add a filter.

  2. Instead of adding an actual value for the filter, a @<control tag ID> can be defined.

ControlTagFitler

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. For example, if two sales channels were selected in the above example, the where clause added by Bizview would be:

innersql

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).

Published:

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:

dataviewfilter

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.

  1. Click the Selection pane values tab, and the control tag IDs will be shown:

selpaneControlTags

  1. Then, go to the Filters section in dasharea settings and add a filter.

  2. Instead of adding an actual value for the filter, a @<control tag ID> can be defined.

ControlTagFitler

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. For example, if two sales channels were selected in the above example, the where clause added by Bizview would be:

innersql

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).

For an optimal Community experience, Please view on Desktop
Powered by Zendesk