Standalone table replica not populating with data in offline environment

189
1
05-24-2022 02:38 PM
Dirk_Vandervoort
New Contributor III

I have a standalone table in my web map - the table is not related to any of the feature layers. The purpose of this standalone table is to perform complex lookups based on a combination of data and events - the standalone table is queried in the Field Map map via Arcade code embedded in a field's Calculated Expression. 

In a connected environment the Arcade queries the standalone table just fine - the expected results are obtained. The Field Maps obtains content from the standalone lookup table.

In a disconnected offline environment the Arcade queries the replica standalone table just fine except that it does not return any rows. A row count in Arcade returns a zero. The standalone table is verified to exist using Arcade. Apparently the table replica has no rows.

Upon closer inspection I found the SQLite geodatabase file that gets included in the map package that gets delivered to the Field Maps application. Cracking open the SQLite database confirms that the table exists but that it has no rows.

That's my problem:  The replica standalone table not populating with data in online environment.

Is there a way to populated those standalone tables by overriding the default "no data" behavior? I am using the Field Maps web app to create the offline areas, and by association the SQLite geodatabase file. I would be comfortable scripting this operation if there was a bit to override the default "no data" behavior. TIA

0 Kudos
1 Reply
ChadMinteer
Occasional Contributor

We also had this issue with a custom app.  We got some guidance and implemented our own packaging workflow that mimics the web map offline area packaging, but it implements a couple of parameters in the Setup Map Area REST API call in order to get records in the standalone table.  Hopefully the configuration options in 'Advanced Options' can be enhanced to include an option to populate standalone tables or not.

Specifically, we are using the optional featureServices request parameter with a layerQueries parameter to get the table records.

https://developers.arcgis.com/rest/packaging/api-reference/setup-map-area.htm

0 Kudos