Conditional filters

Question

Hi.I'd like to build a dashboard on products' sales where available filters' contents should vary according to the logged user. How can I do that?Is it possible to integrate the dashboard with a VB.NET application so that I could invoke the dashboard from the application and pass some parameters?Thank you.

Sammanasu Mary Jesuraj · Answer

Hi Paulo, 

Thank you for contacting Syncfusion support. 






Query 

Response 


I'd like to build a dashboard on products' sales where available filters' contents should vary according to the logged user. How can I do that? 

At SDK Level, You can filter the dashboard based on the current user by passing the current user within filterParameters API. Passing the parameter will filter dashboard at the initial render itself. To know more about the filterParameters follow the below link 
https://help.syncfusion.com/dashboard-platform/dashboard-sdk/how-to/apply-filter-using-filterparameters-api#passing-parameter-with-filterparameters-api 
To filter the dashboard based on the filter parameter using the filterParameters API pass the current username as in the below code snippet 





$("#dashboard").ejDashboardViewer( 
            { 
                serviceUrl: 'service URL', 
                dashboardPath:'Path of the dashboard', 
                filterParameters: "UserName=Thomas Hardy",  \ User Name must be a column in the data Source 
            } 
    ); 

At Dashboard Designer end, We can achieve the requirement – “The data need to be displayed based on the logged user” with “User based filter” feature of Dashboard Designer application. 

Please refer the below link for more details to achieve your requirement. 
https://www.syncfusion.com/kb/7729/how-to-achieve-row-level-security-in-dashboard-designer 

Please refer the below UG documentation link to know more details about configuring user based filter. 
https://help.syncfusion.com/dashboard-platform/dashboard-designer/compose-dashboard/configuring-user-based-filter/using-user-filter-window 




Is it possible to integrate the dashboard with a VB.NET application so that I could invoke the dashboard from the application and pass some parameters? 

Yes it is possible to integrate the dashboard with VB .NET application. Please find the sample to embed the dashboard in VB .NET application 

http://www.syncfusion.com/downloads/support/directtrac/203054/ze/OnlineEmbeddedDashboard_1976333111 



Regards, 
Sammanasu Mary J.