We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

filter data based on current User / User data permissions (row-level)

Thread ID:





121493 Dec 21,2015 03:00 AM UTC Apr 25,2016 12:34 PM UTC Dashboard Platform 5
Tags: Dashboard Designer
Louis Lavin
Asked On December 21, 2015 03:00 AM UTC

Tables and Views contain data for all sales reps in an organization.  Sales Rep "John" needs to see his data and should not be able to see Sales Rep "Bob'"s data.   How do we implement this row-level filtering based on the currently logged in User?  I couldn't find any information in the documents that described this scenario, so any direction would be appreciated.

Thank you,

Nigin Raj E.C [Syncfusion]
Replied On December 21, 2015 04:36 AM UTC

Hi Louis ,

Thank you for using Syncfusion Products.

Currently we do not have an option to achieve your requirement. We have planned to provide Row level filtering based on current logged in user in our upcoming release on January 2016. As a workaround, you could use URL parameter feature available to restrict the data showcased in viewer. But this is just a work around and does not provide any security. To filter the dashboard view based on a specific user you could type in the following as a parameter with “&” symbol included at prefix to differentiate the basic link and the parameters.

Column Name=Name

On navigating to the above link, only the data relating to the Customer “Brown” will be showcased.

Please let us know if you have any further queries.

Nigin Raj E C

Louis Lavin
Replied On February 22, 2016 10:12 PM UTC

Hi, I am looking for an update on the issue of being able to restrict data based on the current logged in User.  The last reply indicated I should be looking for the "January 2016" update for this feature.  Is there any update on the January release (now that it is towards the end of February)?  I am looking forward to the update, but need to make some plans for our immediate development needs.

Thank you,

Nigin Raj E.C [Syncfusion]
Replied On February 23, 2016 10:37 AM UTC

Hi Louis,

Thanks for your patience .

Row wise security based on user impersonation using Active Directory account is available from our SP2 release (v1.1.0.159) that was made available on 29th January 2016. To explore this functionality, you need to configure the Dashboard Server to use Active Directory account, and the reports that are published in server should have authentication type set as Impersonate. Please follow the below steps to enable impersonation for the dashboard.

1.     In the “Publish Dashboard” window, click on Authentication button
2.       Select the data source and set the Authentication Type as Impersonate

In our main release which is planned on March 2016, we will provide option in dashboard designer for user based filtering in which you can explicitly configure the data to be showcased in a dashboard for each individual user or group.

Please let us know if you have any further queries.

Nigin Raj E C

Joshua Taylor
Replied On April 22, 2016 01:36 PM UTC


Is the user-based filtering Nigin mentioned currently available?  (And is there documentation that someone could point me towards?)



Nigin Raj E.C [Syncfusion]
Replied On April 25, 2016 12:34 PM UTC

Hi Josh, 

                Sorry for the inconvenience caused. Due to some complications in our end we had to drop off User based filter feature from our recent release. We will be providing this feature in our next release. 

Please let us know if you have any further queries. 
Nigin Raj E C 


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon