Can I use returnDictinctValues and resultOffset+resultRecordCount at the same time?

Question

I need to perform a pagination query with distinct values. But when I enable returnDistinctValues and set resultOffSet and resultRecordCount, the query would fail with error messages * Unable to complete operation * Unable to perform query operation The query parameters are * WHERE: = 'value' * OUTFIELD: * returnDistinctValues: true * resultOffset: 1 * resultRecordCount: 20 There is nothing in the Feature Service REST API documentation that says you can't use distinct when doing pagination query. So is it possible to do pagination query on distinct results? Am I doing something wrong?

gpei_ahuang · Accepted Answer

I had a friend putting a inquire request to ESRI and this is the response

We have one instance of this inquiry having had happened with Esri Inc many years ago.

The developers and product managers noted that pagination is not supported with outStatistics or returnDistinctValues on feature layers. The thoughts are that when making this kind of query, with its specificity, it should not need to return 1000s of records, requiring pagination - that number of records would not return any meaningful information. outStatistics and returnDisctingValues are meant to be used only on a handful of records, not 1000s.

We don't have any specific recommendation for you to suggest avenues to work around this design.

What would likely need to happen is that the data would need to be manipulated at the database level, through specific SQL queries or data manipulation, prior to it being published as a service. In this way, the query either would not require distinct values, or would not require pagination.

I guess we won't get a function anytime soon