FeatureTable Distinct Query

Question

Is there any way to perform a distinct query on a FeatureTable? We need it to work with both ServiceFeatureTable and GeodatabaseFeatureTable.

It seems like the answer is 'no', given that QueryParameters does not have the option for it. Or does there happen to be some secret undocumented trick that could get the job done?

If it's not possible as I suspect, could we get that added to a future release? Seems like a basic requirement that's missing here.

Also, FWIW, the capability does exist in javascript.

https://developers.arcgis.com/javascript/latest/api-reference/esri-rest-support-Query.html#returnDistinctValues

FelicityRhone · Answer

Any update on this?

jsiemensLatitudegeo · Answer

Thanks Mike, for the response and the details on this one.

MichaelBranscomb · Answer

We haven't currently exposed this directly in the API and it is an existing enhancement request: ENH-000109194. Some investigation was done relatively recently but unfortunately that determined it's not a trivial task to implement at this time, which likely means it's not on the near-term roadmap. I've added your info to our internal tracking issue.