1. Home
  2. Forum
  3. Dashboard Platform
  4. filter Column data base on Current user

filter Column data base on Current user

Hello Team,

we have created report in syncfusion tool and its looking great and work perfect, now we need some customize at one column data show,  we need like some user can view column data and another can't  and that  permission need base on current user.
for that type of requirement i have some quesion
1) how can we get current user who use report ?
2) can we pass this current user as parameter to stored procedure ? (if i can pass user as parameter then i can make this functionality)
here i send you scenario where we need such functionality in attachment file, 
Please guide in this case as soon as possible 

Thank you


Attachment: column_security_6f508d2b.7z

1 Reply
VS Venkataprasad Subramani Syncfusion Team June 5, 2018 01:02 PM UTC

Hi Gajrajsinh Rathva, 

Thanks for contacting Syncfusion support and please find the response for your queries. 

Query 
Response 
how can we get current user who use report ? 
You can get the current user information in the dashboard by using the following ways.

1. Using the User based filter: User Filter allows you to limit the data view of the published dashboard based on the logged in user. The user information will be referred from Dashboard Server user accounts. Once the dashboard is published to Dashboard Server, the view details in dashboard gets adjusted based on the logged in user.

Please find more details on user based filters from the UG documentation page:
https://help.syncfusion.com/dashboard-platform/dashboard-designer/compose-dashboard/configuring-user-based-filter/using-user-filter-window  
2. Using the Dashboard parameters:  You can get the current user information such as user name, user full name and user mail Id by creating the Literal mode dashboard parameters.  

can we pass this current user as parameter to stored procedure ? (if i can pass user as parameter then i can make this functionality) 
To pass the current user information as a parameter to the stored procedure you can follow the below mentioned steps.  


  1. Create a literal mode dashboard parameter similar to the below screenshot.
  2. Use the created dashboard parameter in the stored procedure.


    Select the dashboard parameter and click update.

    Note: The data in the column which matches the value in the dashboard parameter will be displayed.
  3. Save the dashboard report and publish to the dashboard server. The records will be shown based on the currently logged in user.


Please let us know if you require any further assistance on this.  

Regards, 
Venkataprasad S. 


Loader.
Up arrow icon