topic Alteryx Gallery Capabilities in Alteryx Server Discussions

Alteryx Gallery Capabilities

Madihah_29 — Fri, 17 Nov 2023 02:05:23 GMT

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!

Re: Alteryx Gallery Capabilities

gawa — Fri, 17 Nov 2023 02:02:54 GMT

@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.

Re: Alteryx Gallery Capabilities

Luke_C — Fri, 17 Nov 2023 21:56:05 GMT

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.

Re: Alteryx Gallery Capabilities

Madihah_29 — Mon, 20 Nov 2023 07:50:36 GMT

Nice thanks for the suggestion!

Re: Alteryx Gallery Capabilities

Madihah_29 — Mon, 20 Nov 2023 07:54:18 GMT

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?

Re: Alteryx Gallery Capabilities

Luke_C — Mon, 20 Nov 2023 13:58:14 GMT

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.