Hi all, I'm still new to Alteryx Gallery. I would like to know if it is possible for us to filter the data based on the user's location in Alteryx Gallery.
For example, if the user logs in from Pennsylvania, then only the data from Pennsylvania will be displayed.
Are there any suggestions or idea that you guys have? Really appreciate your suggestions. Thanks!
@Madihah_29
If you are talking about "data" as asset on server like workflow, scheduler, so on, you should manage access by user group and collection.
First, create user groups for each location, and include users to those groups.
Second, create collections for each location, and add user group to each collection.
You can mage users access and asset this way.
Hi @Madihah_29
More clarification would be helpful, but yes, you can pass the logged in user through to the workflow leveraging chained apps. I've done this to help populate drop downs with options based on the user's access in other systems.
At a high level, the first workflow in the chained app serves to collect the user's ID. To do this you use text input named __cloud:UserId. You need to have a connection to the mongo DB to get the user's email, which then you can then compare against your company's info to get location.
Then that data will seed the second workflow.
Nice thanks for the suggestion!
Thanks a lot for the suggestion. Could you please explain more regarding that? I wish to do like this too. Could we use MongoDB for retrieve user's location?
Hi @Madihah_29
It's likely that the user table in the mongo DB won't have your user's location. I read my company's active directory in as a secondary source and join on the email.
User | Count |
---|---|
5 | |
1 | |
1 | |
1 | |
1 |