Section Access on Server

[caltang]

A build of mine is connected to a DB with multiple tables for each country. 

I'm trying to build something which can be used by all of them, but limited to their own country.

Should I:

Option A: Utilize the collections for each country and load the same workflow multiple times and assign users to those particular collections?

OR

Option B: Is there a way where I can have 1 collection where all users can go in, and section access the data (row-level etc.) to their specific country? Is there a way to do this?

Thanks all!

-Cal

[fmvizcaino · Accepted solution]

Hey @caltang ,

One idea is to get the userID using a text box and merge it with the mongoDB user collection data to retrieve the user's country and go from there.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Get-username-Cloud-not-working...

https://community.alteryx.com/t5/Alteryx-Server-Discussions/Accessing-the-logged-in-User-name-in-a-w...

Best regards,

Fernando Vizcaino

[caltang]

Thanks @fmvizcaino !

This is exactly what I'm looking for. Appreciate it.