topic Re: Filter Data and Chart based on Login in ArcGIS Dashboards Questions

Filter Data and Chart based on Login

MuhammadNaufalIhsan — Wed, 01 Mar 2023 07:56:47 GMT

Hi,

Is there anyway to filter data and chart in dashboard (or experience builder) based on the user login? The idea is when user A login, the dashboard will only shown the user A data and he/she will not be able to see the data created by other user. The rule will be also applied to charts or widgets related to the data.

Regards,

Naufal

Re: Filter Data and Chart based on Login

jcarlson — Wed, 01 Mar 2023 12:58:53 GMT

Yes, there is! It's a feature we make use of in some QC dashboards, making sure that users provide additional review to the work of others, but not themselves.

To get it to work, you need to use a Data Expression. In the Arcade expression, you'll have a chance to call the function GetUser, and then use that to filter the data on the way in.

var curr_user = GetUser()['username'] var fs = FeatureSetByPortalItem( Portal('your portal url'), 'itemid of the feature service', 0, // or whatever the layer index is, if not 0 ['*'], true ) return Filter(fs, `created_user = '${curr_user}'`

The data returned by this expression will be specific to the logged in user, and will apply to all widgets which reference the same data expression. Try it out!

Re: Filter Data and Chart based on Login

MuhammadNaufalIhsan — Fri, 03 Mar 2023 08:20:19 GMT

Hi Josh,

Thank you! I will try it.

By the way, is there any way to filter it by group that the login user is a member in it?

Regards,
Naufal

Re: Filter Data and Chart based on Login

jcarlson — Fri, 03 Mar 2023 14:42:29 GMT

Yes, there is!

When you use the GetUser function, the object that is returned has a number of properties, not just the username. One of them is an array of groups.

Each group in the array has its own values, too.

How you use that list of groups and apply it to a filter depends on what you're wanting to do, but you could check the array for the presence of a certain group, or else just use the list of groups to filter by an attribute, etc.

Re: Filter Data and Chart based on Login

MuhammadNaufalIhsan — Mon, 06 Mar 2023 17:22:47 GMT

It works! Thanks a lot!

Although, getting group info from the array is quite tricky. But so far it works, so thank you again!

Regards,
Naufal

Re: Filter Data and Chart based on Login

Tweed_ShireAdmin — Thu, 20 Apr 2023 04:41:41 GMT

Is there a way to do this in Experience Builder using the chart widget? I do not see an option to add in an Arcade expression anywhere when using the chart widget in Experience Builder.

Re: Filter Data and Chart based on Login

OlivieroVitale — Tue, 30 Jan 2024 18:24:22 GMT

Unfortunately not yet

Re: Filter Data and Chart based on Login

Nicole_Ueberschär — Fri, 23 Feb 2024 06:11:33 GMT

We have been looking for this forever, thank you! Unfortunately I can't make it work, it keeps telling me that it's "unable to execute the Arcade script" although the test result is exactly as expected. I was further wondering how I can make this apply to the content of my map? Maybe it is so obvious that I don't see it...

Edit: I can make it work in ArcGIS Online but unfortunately not in Enterprise 11.1 and the way I see it work for the map content would be to use a selector with the filtered expression and not to put the none option so it automatically filters to that selection.

Re: Filter Data and Chart based on Login

PaulPetersen1 — Wed, 06 Mar 2024 18:32:25 GMT

@Nicole_Ueberschär , we are having the same issue with Portal 11.1. Did you ever find a resolution or workaround?

Re: Filter Data and Chart based on Login

Nicole_Ueberschär — Wed, 06 Mar 2024 19:48:08 GMT

Hi @PaulPetersen1 , Unfortunately I couldn't make it work in Portal 11.1.

I found in the developer console that there seems to be an issue around that it doesn't recognize the result as a featureset:

error predictOutputType: "Analysis not supported" script: Write an expression that returns a FeatureSet.

I don't see though why the result of the expression is not be a featureset when the test inside the Arcade expression is successful.

I am also still looking for a better way of filtering the map content itself (in 11.2 now). It works well if we have only one district for example looking at the data for that district. But if we filter on Province level (one level up) then that person is supposed to see 7 districts and with the current options I found, he will only be able to see one district when loading the dashboard. I have been breaking my brain over trying to find a way to show all 7 districts but only those 7 districts... It is ok as long as we have have only users on the same level but not from different levels 😞

Re: Filter Data and Chart based on Login

PaulPetersen1 — Wed, 06 Mar 2024 21:06:01 GMT

Hi @Nicole_Ueberschär , just a little bit after making my first post, we figured out how to get it to work. Turns out that the getUser() function was somehow causing the issue (even though the Test would work). After tweaking the function a bit, it now works. See below.

var port = Portal('https://xxxx.com/portal'); var fs = FeatureSetByPortalItem( port, 'xxxxxxxxxxxxxxxxxx', 0, [ 'Inspector' ], false ); Console(Count(fs)) // to get number of features in feature service in Console var u = getUser(port); var fullName = u.username; Console (fullname) // to check in the Console that the fullname is returned var filfs = Filter(fs, `Inspector= '${fullname}'`) // change field as needed Console(Count(filfs)) // check in Console that it is returning the correct number of features assigned to the user return filfs

Re: Filter Data and Chart based on Login

Nicole_Ueberschär — Thu, 07 Mar 2024 12:42:51 GMT

Thanks a lot for this @PaulPetersen1 ! What difference the case of a letter can make! 😲

Any idea what to do about the map content?

Re: Filter Data and Chart based on Login

PaulPetersen1 — Thu, 07 Mar 2024 15:04:26 GMT

@Nicole_Ueberschär , no not sure about the map content. If you don't have tons of users or groups, you could perhaps try something with hosted views with separate group permissions and filters...handle it there rather than in the dashboard. I've also had success in solving "filter puzzles" by using the NOT operator rather than Equals and coming at things from the opposite angle. Probably not helpful for your situation.

Re: Filter Data and Chart based on Login

Nicole_Ueberschär — Wed, 13 Mar 2024 09:03:54 GMT

Thanks @PaulPetersen1 , we managed to do it using the url parameter option from the dashboard and then embed it into an application in which we use javascript to create the url based on the signed in user.

Now I am having the same problem with limiting the content in a Web Appbuilder application. Any idea ? Using views is just not feasible for 30+ users 😞

Re: Filter Data and Chart based on Login

PaulPetersen1 — Wed, 13 Mar 2024 14:18:20 GMT

@Nicole_Ueberschär , glad you got it going with URL parameters. No, I don't have any experience with Web App Builder, when it comes to limiting content. You may look into whether it can support URL parameters as well, or see if shifting to Experience Builder is viable.

Re: Filter Data and Chart based on Login

YobaniMaldonado — Thu, 03 Oct 2024 11:44:22 GMT

Does anyone know if this is possible in Experience Builder?