QueryFilter OFFSET and FETCH

JonathanBurmeister — Wed, 01 Feb 2023 21:16:40 GMT

Hello everyone,

I am attempting to use a QueryFilter to query a Feature Service Feature Class with the ArcGIS Pro 2.9 API. Using the GetSQLSyntax() and GetSupportedClauses(), I am able to determine the ORDER BY clause is supported. The ORDER BY clause functions properly when simply adding the sorted field names in the QueryFilter PostfixClause.

For example: ORDER BY FILED1, FIELD2

However, I would like to use the OFFSET and FETCH options of the ORDER BY clause to control the query results.

For example: ORDER BY FILED1, FIELD2 OFFSET 0 ROWS FETCH NEXT 200 ROWS ONLY

Is it possible to use the OFFSET and FETCH options of the ORDER BY clause when querying the Feature Service Feature Class using a QueryFilter? If so, is there a specific syntax that needs to be used for it to function properly?

I have been having trouble determining if the ORDER BY OFFSET and FETCH options are supported when querying feature services. The Query (Map Service/Layer) REST endpoint supports resultOffset and resultRecordCount at enterprise 10.3. So, I would like to assume OFFSET and FETCH is supported in the ArcGIS Pro 2.9 API, but I cannot find any documentation.

Thanks for any help, Jon

Re: QueryFilter OFFSET and FETCH

Aashis — Thu, 30 Mar 2023 21:35:52 GMT

Unfortunately, the Offset and Fetch clauses still need to be supported in the QueryFilter and planned for future releases.

Re: QueryFilter OFFSET and FETCH

JonathanBurmeister — Thu, 03 Aug 2023 22:07:39 GMT

Thanks for the reply

topic QueryFilter OFFSET and FETCH in ArcGIS Pro SDK Questions

QueryFilter OFFSET and FETCH

Re: QueryFilter OFFSET and FETCH

Re: QueryFilter OFFSET and FETCH