Filter out Dataset using the user's Gallery authentication details

[Constantinosch]

Hello everyone,

Hope you are doing well. 

We have a case where we are trying to filter the dataset due to users access rights on the database when running a routine on Gallery.

The idea is that after publishing a routine on our Gallery, the workflow will identify who runs it using the gallery authentication and then use it as a filter to output the data. We are trying to find a better solution rather than creating multiple workflows for each user and then sharing it individually , where in this case we need only one routine and the workflow will do the rest. 


Thank you very much!

[TimN · Accepted solution]

Hi,

Here is a link that may help.

https://community.alteryx.com/t5/Alteryx-Server-Discussions/Connecting-to-Row-Level-Security-Data-So...

Regards,

Tim

[Constantinosch]

Hello Tim,

Thank you for the article i will take a look at it and see if it can help us !

Regards,
Constantinos

[Constantinosch]

Hey Tim,

Thank you very much!

i've tested the part where you user __cloud:UserID and it works like a charm !

This saved us a lot of manual work