Records count is missing on ArcGIS Survey123 reports when using referenced feature services published to ArcGIS Enterprise from an Oracle database.

Workaround

It is caused by capitalization of fields in dataset, Oracle implements this automatically.

Syntax for queries in default summary can be changed to below to allow for record counts in report to display:

• Selected record count: ${#Events | stats:"count,OBJECTID,COUNT_OBJECTID":"":""} ${COUNT_OBJECTID}${/}
• Total record count: ${#Events|where:"1=1 !important"|stats:"count,OBJECTID, COUNT_OBJECTID":"":""}${COUNT_OBJECTID}${/}

Hashtag (#) allows for query of fields that are capitalized.

Schritte zur Reproduzierung