RevealBi/Documentation

Row Level Security - Update Data Source topic to use UserContext / Custom Query

jberes opened this issue · 0 comments

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.

https://help.revealbi.io/web/replacing-data-sources/ms-sql-server#example-replace-host-database-and-table

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?

image