topic Return non-used domain values in Dashboard List in ArcGIS Dashboards Questions

Return non-used domain values in Dashboard List

JeffMiller7 — Fri, 18 Feb 2022 17:24:06 GMT

Good day all!

I have a dashboard set up that summarizes the current status of ongoing construction projects. In my projects layer, I have a field for Inspector, which references a domain list consisting of all available inspectors. I am attempting to set up a list widget that lists all of the available inspectors found within that domain that are not currently assigned to a project. I have played around with the domain function in Arcade, but seem to be having trouble getting it to work properly.

I am curious if this is even a possibility, but I thought I would throw it out there to see if anyone had ever attempted something similar. Any input you could provide would be most welcomed!

Re: Return non-used domain values in Dashboard List

HuubZwart — Fri, 18 Feb 2022 18:17:53 GMT

This should be possible using a combination of the FeatureSetByPortalItem (or any of the other FeatureSet functions) and Schema. Schema allows you to get all of the coded domain values via the fields/domain properties.

Something like this:

var somelist = [] function myfilter(someval){ return indexOf(somelist, someval) == -1 } var coded_values = Schema($feature)['fields'][4]['domain']['codedValues'] for(var i in coded_values){ Push(somelist, coded_values[i]['name']) } var fs = FeatureSetByPortalItem(Portal('PORTALURL'), "ITEMID", LYR_INDEX) var in_use_list = [] for(var f in fs){ Push(in_use_list, f.FIELDNAME) } return Filter(in_use_list, myfilter)