We are running ArcGIS Enterprise 10.9 and have created a SBDS using the Geoevent Server. When trying to query the layers of the associated Feature Services for distinct records using multiple output fields, we get the following error message (see screenshot in addition):
"Return distinct values query is not supported for multiple fields on Elasticsearch, returnGeometry must be false."
However, the documentation of the ArcGIS REST API on Query (Feature Service/Layer) states:
returnDistinctValues | If true, it returns distinct values based on the fields specified in outFields. This parameter applies only if the supportsAdvancedQueries property of the layer is true. This parameter can be used with returnCountOnly to return the count of distinct values of subfields. |
The returnGeoemetry option was set to "false", and the supportsAdvancedQueries of the FeatureService/layer is "true". From this I would assume that it should be possible to return Distinct Combinations of fields from the feature Service. Am I something missing here, or is this a mistake in the documentation?