devexpress-examples / web-forms-dashboard-update-parameter-master-filter-changed Goto Github PK

View Code? Open in Web Editor NEW

How to pass filter values to a parameter in the ASP.NET Web Forms Dashboard

License: Other

C# 37.19% ASP.NET 20.81% Visual Basic .NET 36.53% JavaScript 5.48%

web-forms-dashboard-update-parameter-master-filter-changed's Introduction

Dashboard for Web Forms - How to update the dashboard parameter value when the item's master filter state is changed

This example illustrates how to pass master filter values to a hidden dashboard parameter.

The Orders grid item is bound to the Orders data source, and the Details pie item is bound to the CustOrdersDetail data source. The grid's master filter values are passed to the OrderID dashboard parameter that is used to filter the CustOrdersDetail data source (the OrderIDParameter query parameter is mapped to the OrderID dashboard parameter):

The ViewerApiExtensionOptions.onItemMasterFilterStateChanged event handler obtains changed master filter values. The DashboardParameterDialogExtension.getParameters method obtains the dashboard parameters. The DashboardParameter.setValue method passes master filter's values to the OrderID dashboard parameter:

var dashboardControl;

function onBeforeRender(s, e) {
	dashboardControl = s.GetDashboardControl();
	var viewerApiExtension = dashboardControl.findExtension('viewerApi');
	if (viewerApiExtension)
		viewerApiExtension.on('itemMasterFilterStateChanged', onItemMasterFilterStateChanged);
}
function onItemMasterFilterStateChanged(e) {
	if (e.itemName == "gridDashboardItem1") {
		var dashboardParameterDialogExtension = dashboardControl.findExtension('dashboardParameterDialog');
		var parameters = dashboardParameterDialogExtension.getParameters();
		var parameter1 = parameters.getParameterByName("OrderID");
		parameter1.setValue(e.values[0][0]);
	}
}