Row Level Security - Update Data Source topic to use UserContext / Custom Query
jberes opened this issue · 0 comments
jberes commented
In this topic:
https://help.revealbi.io/web/replacing-data-sources/ms-sql-server
Add code for NodeJS as well as an example to override the / augment the query being passed with the UserContext.
The scenario:
My database has an identifying column that I need to filter on before returning data for a visualization in a dashboard.
I need to pass the user context in the query to the database.
What is the best way to achieve this in code?