topic QueryFilter PostFix Clause Not Working With Shapefiles in ArcGIS Pro SDK Questions

QueryFilter PostFix Clause Not Working With Shapefiles

estz2 — Fri, 27 Oct 2023 22:47:47 GMT

Hi all, first post here so let me know if I filled this out wrong.

I am working on an add-in that uses the postfix clause of a queryfilter to order the results. I ran into a bug where a feature layer sourced from a shapefile doesnt sort correctly or at all (just returns rows in order of object id when my postfix was for a different column ascending). When I saved the same feature layer to a geodatabase and added it back into the project, the postfix clause worked just as expected (sorted correctly).

Here was the code block in question:

var queryFilter = new QueryFilter { WhereClause = $"{treeLayerInfoFields["objectid"]} IN ({string.Join(",", batch)})", PostfixClause = $"ORDER BY {treeLayerInfoFields["dbh_in"]} ASC", };

Has anyone else ran into shapefile-sourced feature layers not working when querying with a postfix clause?

Thanks!

Re: QueryFilter PostFix Clause Not Working With Shapefiles

GKmieliauskas — Sun, 29 Oct 2023 07:10:16 GMT

Hi,

Shapefiles have some limitations.

DISTINCT, ORDER BY, and ALL are only supported when working with databases. They are not supported by other data sources (such as dBASE or INFO tables).

SearchCursor—ArcGIS Pro | Documentation

You could try to use Table method Sort.

Re: QueryFilter PostFix Clause Not Working With Shapefiles

estz2 — Mon, 30 Oct 2023 15:43:52 GMT

Thank you!