FeatureSetByName or ByID with Flat Table?

261
4
08-24-2020 08:08 AM
InvenergyGIS_User
New Contributor

I am getting no records returned from a FeatureSetByID Arcade expression for a flat table in my $map or $datastore.  Is this expected behavior?  Does the FeatureSet function work on flat tables or only on spatial data?

FeatureSetById($datastore, "2") returns the field names, but no data.

Using ArcGIS Enterprise 10.7.1

Tags (1)
0 Kudos
4 Replies
XanderBakker
Esri Esteemed Contributor

Hi Invenergy GIS User ,

Arcade can work with flat tables and featurelayers. 

Did you construct this line manually or did you use the interface to create it, like this: 

If the test returns an empty featureset (just field names) you should check is the service is up and working correctly. 

0 Kudos
DavidTreering1
New Contributor II

Thanks, Xander Bakker‌!

I used the interface as in your screenshot.

I gave the records in the flat table a fake lat/long and republished so it became a spatial featureset.  Then the FeatureSetByName and ByID work fine.

You said Arcade works with flat tables, which I see is true, but that particular function just gives me empty featuresets.

0 Kudos
XanderBakker
Esri Esteemed Contributor

Hi David Treering ,

I'm glad you could make it work, but it remains strange that without the coordinates it is not working for you. What version of Enterprise are you using?

0 Kudos
DavidTreering1
New Contributor II

10.7.1