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

[Louis Lavin]

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,

Louis

[Nigin Raj E.C]

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
Eg:
http://dashboardserver.syncfusion.com/dashboards/view?id=275acc8f-e30d-4b5d-9899-d05d09e9be6e&CustomerName=Brown

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.

Regards,
Nigin Raj E C

[Louis Lavin]

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,

Louis

[Nigin Raj E.C]

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
           http://www.syncfusion.com/downloads/support/forum/121493/ze/Publish_Window1545072843

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.

Regards,
Nigin Raj E C

---

JT Joshua Taylor April 22, 2016 01:36 PM UTC

Hi.

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

Thanks!

-Josh

---

NR Nigin Raj E.C Syncfusion Team 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. 

Regards, 

Nigin Raj E C 

[Joshua Taylor]

Hi.

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

Thanks!

-Josh

[Nigin Raj E.C]

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. 

Regards, 

Nigin Raj E C