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; } } }

FeatureSet not working offline in Field Maps

Scott_Sambell

We added calculated expressions to several of our clients' Field Maps after promising that they would have all the functionality now in smart forms that we have been raving about. Everything works perfect using Field Maps online but when we did the final test (download an offline area and sync test) we discovered that the FeatureSet function does not work offline. We tried it on several different Android and iOS devices on several different webmaps. This is an absolute showstopper for us. Is this a bug or a known limitation? We need to know asap so we can explain to the clients why they aren't getting what we promised

Here is an example of how we use FeatureSetByName:

var tblparent = FeatureSetByName($map, "Trap locations",['OBJECTID','Easting_Northing','GlobalID'],False);

Maybe other FeatureSet functions work but FeatureSetByName($Map,...... doesn't? Any explantation i could get would be much appreciated.

Thanks!

@JeffShaner

Find more posts tagged with

Accepted answers

Anonymous User

@Scott_Sambell While we investigate a full fix, there's a potential workaround. The issue appears to be related to case sensitive GUID value comparisons. If you cast your foreign key (the GUID) to upper, it should work.

var recordGUID = upper($feature.ASSETGUID);  // <------ ALTERATION HERE
var recordSet = $featureSet;
var subset = filter(recordSet,`ASSETGUID  = '${recordGUID}'`);
var ordered = orderby(subset,'InspDate DESC');
var firstInspec = first(ordered);
if (IsEmpty(firstInspec)) {
    return 0;
} else {
    return firstInspec.PRESSURE;
}

I tested this in my own map and it seemed to work.

All comments

rzufelt

there are some issues with GetUser() in Field Maps app. Try this to see if it gets the username for you:

var me = GetUser(FeatureSetByName($map,"staff_LUT")).username
var filtered = Filter(lut, `label2 = '${me}'`)

Also, remember that if offline, a count (or any other operation) will only work on the features that are currently 'downloaded' into you offline area. Is it possible that the offline are you are testing is outside of the 184 points in the data?

Samuel_McAuley

I am experiencing a similar issue with FeatureSetByName not working offline. In this example, I am attempting to use the user property 'username' to lookup a staff ID number in a standalone lookup table within the map. I know that only certain user properties are available offline using GetUser($layer), but username is definitely one of them as I can return that no problem. The issue is when I try to filter the lookup table using that property. Online it executes without a hitch, however offline it is returening 0 records. I have tried returning the staff ID and also just the count of records returned from the filter function. The count consistently returns 0 when offline and 1 when online.

Below is my code snippet.

var me = GetUser($layer).username
var lut = FeatureSetByName($map,"staff_LUT")
var filtered = Filter(lut, 'label2 = @me')
return First(filtered).name

In addition to this, I tried to just reference the table and return the count of records in it (see below), and when online it returned 184 as expected, however offline it returned 0.

return count(FeatureSetByName($map,"staff_LUT"))

Any advice would be greatly appreciated

KelseySmuczynski

Oops, looks like I missed applying the IsEmpty function to the ref_guid in line 3. I updated my code as shown below and it tested without issues. I'll still need to see if the changes applied to my offline maps, but will report back soon.

UPDATE: IT WORKED!

Thanks, @RhettZufelt and @Anonymous User . You guys are rock stars.

var ref_guid= upper ($feature.GUID)

if(IsEmpty(ref_guid)) { //<-- applied IsEmpty()here
return null
}

var wells_fs=FeatureSetByName($map,"Wellsites2")
var wells_filter = Filter(wells_fs, `GlobalID = '${ref_guid}'`)
var well = First(wells_filter)

if (IsEmpty(well)){
return null
}
return well.Well_Name

KelseySmuczynski

Hey Rhett,

Thanks for the quick reply. I tried your suggestion (code below), but still received the same error.

var ref_guid= upper ($feature.GUID)

if(ref_guid == null) {
return null
}

var wells_fs=FeatureSetByName($map,"Wellsites2")
var wells_filter = Filter(wells_fs, `GlobalID = '${ref_guid}'`)
var well = First(wells_filter)

if (IsEmpty(well)){
return null
}
return well.Well_Name

Also, just to clarify, my initial code (below, just in case) was successfully populating fields in my inspection form with info from my related feature class. It stopped working when I created and used an offline map for data collection.

//Initial code that was successful in non-offline mode.

var ref_guid= $feature.GUID // <---No upper casting

if(ref_guid == null) {
return null
}

var wells_fs=FeatureSetByName($map,"Wellsites2")
var wells_filter = Filter(wells_fs, "GlobalID = @ref_guid")
var well = First(wells_filter)

if (well == null) {
return null
}
return well.Well_Name

Kelsey

rzufelt

Testing == null does not seem to catch null/empty values.

What happens if you replace the two if statements with similar code as below (and in Aarons post above):

if (variable == null){

with

if (IsEmpty(variable )) {

Also, look at your filter statement. It appears as if you are just filtering for "GlobalID = @ref_guid" which would only match if the value of that cell = "@ref_guid" and not substituting the variable value.

Suspect it is looking for something more like the previous examples in this post:

var subset = filter(wells_fs,`GlobalID = '${ref_guid}'`);

KelseySmuczynski

Hi Aaron,

I also have the issue of my calculated expression not working in offline mode. I updated my expression by casting my GUID as you suggested, but when I tested it I received an error message, Execution Error: Error. Below is my code (with the casted GUID) that threw the error. Also attached is a screenshot with the error message.

var ref_guid= upper ($feature.GUID)

if(ref_guid == null) {
return null
}

var wells_fs=FeatureSetByName($map,"Wellsites2")
var wells_filter = Filter(wells_fs, "GlobalID = @ref_guid")
var well = First(wells_filter)

if (well == null) {
return null
}
return well.Well_Name

Any suggestions on how best to resolve or work around this issue?

wellname_expression.PNG

Scott_Sambell

Looks like you've done it Aaron! Its working offline and syncing.

Thanks so much, you are a legend. Can't wait to get it out there and start using it!

Scott_Sambell

@WillyG Try this.

Scott_Sambell

Thanks Aaron this is going to be amazing if it works. We'll give it a go today and let you know how we go.

thanks so much!

Anonymous User

var recordGUID = upper($feature.ASSETGUID);  // <------ ALTERATION HERE
var recordSet = $featureSet;
var subset = filter(recordSet,`ASSETGUID  = '${recordGUID}'`);
var ordered = orderby(subset,'InspDate DESC');
var firstInspec = first(ordered);
if (IsEmpty(firstInspec)) {
    return 0;
} else {
    return firstInspec.PRESSURE;
}

I tested this in my own map and it seemed to work.

Scott_Sambell

Thanks Aaron!

Anonymous User

We reproduced this in-house and have opened an issue to investigate further.

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.