nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

FeatureSetBy Arcade Functions Supported in Field Maps App?

danbecker

Enterprise 10.9, Map Viewer BETA. Created a popup expression using the FeatureSetByRelationshipName function. I can successfully retrieve the parent feature attribute in the popup, no issues.

But, when the webmap is accessed with the Field Maps app (Android) the popup shows an Error Code 6, Illegal State. Invalid relationship name.

Question of the day: Are any of the FeatureSetBy.. Arcade functions supported in the latest field maps app? If so, does the map have to be online, ad-hoc created offline, or pre-defined offline?

thanks.

Find more posts tagged with

Accepted answers

danbecker

Here's the solution, scrap the Arcade Filter() function, it simply does not work with globalid while offline.

This expression works fine both online/offline. Upper/Lower case globalid wasn't the issue, both FM and map viewer BETA in Enterprise 10.9 were displaying Upper case. But, just for safety I used Lower.

var relate_guid = $feature["rel_guid_pcs"];
var featSet = FeatureSetByName($map,"Point Count Stations", ['pcs_id','globalid'], false);
for(var feat in featSet){
    if(Lower(feat.globalid)==Lower(relate_guid)){
        return feat.pcs_id;
    }
}

All comments

danbecker

Here's the solution, scrap the Arcade Filter() function, it simply does not work with globalid while offline.

danbecker

Online, both app and Map Viewer BETA both of these filter expressions work, offline in app, neither of them work.

"globalid = '" + relate_guid +"'"

"globalid = @relate_guid"

Online/Offine, this filter expression works:

'objectid > 0'

@DougBrowning, can you try a filter expression in your environment that uses globalid? It would be great if you could repo this.

dougbrowning

Well map viewer BETA does not support relationships classes yet. No button for it at all so that is prob not going to work out.

Next I wonder of you are finding the lower vs upper case globalID problem. Field Maps is doing lower while AGOL is upper and it is causing me pains. See here https://community.esri.com/t5/arcgis-field-maps-questions/field-maps-is-creating-lowercase-globalid-but-agol/m-p/1126721

Above it looks like you are not using the filter right. You need to filter by global. See my example.

danbecker

But, this edited Arcade Expression does work offline!

var relate_guid = $feature["rel_guid_pcs"];
var featSet = Filter(FeatureSetByName($map,"Point Count Stations", ['pcs_id','globalid','objectid'], false), 'objectid > 0');
return First(featSet).pcs_id;

What changed?

I'm guessing that the offline replica.geodatabase that gets created either:

Doesn't preserve globalid. So the Filter expression: parent.globalid = child.relate_guid doesn't retrieve anything. (I find this hard to believe). I tried adding a new related child point WHILE OFFLINE and the orig. Arcade expression still doesn't work.
the Filter() data fcn doesn't support SQL queries against globalid while offline. (more plausible).

ESRI -- Any docs on this?

danbecker

I cannot get it to work offline, see below details.

Environment: Enterprise 10.9 with PostgreSQL published feature service.

Using map viewer BETA released with 10.9, added both point feature classes, they are related via globalid-guid.

Arcade Expression on child layer:

var relate_guid = $feature["rel_guid_pcs"];
var featSet = Filter(FeatureSetByName($map,"Point Count Stations", ['pcs_id','globalid'], false), 'globalid = @relate_guid');
return First(featSet).pcs_id;

Online result:

both map viewer BETA and Field Maps app (Android) work great. Select a child point and above expression retrieves parent.pcs_id.

Offline result:

same webmap, download ad-hoc offline area in Field Maps app (Android). Select a child point and it displays -- which obliviously doesn't work.

Field Maps app (Android) error:

Expression Name: expr0

Expression Title: Arcade

Error Domain: com.esri.arcgisruntime.ArcGISRuntimeException

Error Code: 15

Error Description: Invalid call.

Unable to evaluate arcade expression. Evaluation_error_code::unexpected_null_value Line

@DougBrowning

1) Are you using AGOL or Enterprise?

2) Hosted feature service or published feature service?

dougbrowning

Yep it works now I kept bugging for it. Offline works also as long as the parent and child are both in the offline replica.

I had seen some have trouble using relationship class name. I always use the layer name from the map and filter based on my key like this. Works great.

var sql = "PointID = '" + $feature.PointID + "'";
var tbl = Filter(FeatureSetByName($map,"Points", ['Use * or a list of fields here'], false), sql);
return First(tbl).DesignLat

My guess on relationship name is it has a longer name somehow like service.rcname or something but not sure.

Hope that helps.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.