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

解决办法

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.

重现步骤