topic Re: Definition query not being honored in ArcGIS Pro Questions

Definition query not being honored

JoeBorgione — Mon, 16 Aug 2021 15:58:21 GMT

ArcGIS Pro 2.7.3

I am unable to get a definition query to work at all. No matter what attribute I try or value(s) it just isn't honored:

I can create a selection query and that works:

Is this a known problem in 2.7.3? I'm planning on an update to 2.8.2 today. Maybe I'll do that sooner than later....

Re: Definition query not being honored

Wolf — Mon, 16 Aug 2021 16:49:19 GMT

Are you using the Pro SDK to define the 'definition query'? You should see on the bottom of the dialog the current active 'definition query', as shown on the screen shot below. Can you share what RDMS you are using and also a sample of you 'definition query' in sql format? If you use the Pro SDK can you share a code snippet for your 'definition query'?

Re: Definition query not being honored

JoeBorgione — Mon, 16 Aug 2021 17:32:23 GMT

OMG that's embarassing.... 😖

Re: Definition query not being honored

BrettJenkinson — Wed, 22 Mar 2023 20:28:12 GMT

I'm having this same issue but this solution did not work. The query box says that my query is active, yet it is showing other data within the layer that clearly do not fit the specified query. My select by attribute option also functions properly. Not sure what the issue is.

Re: Definition query not being honored

Wolf — Wed, 22 Mar 2023 21:14:37 GMT

Can you provide the version of Pro you're using, a screenshot of the SQL Query that is not working, and sample of the rows that are displayed (use the Attribute table for that) even so they don't fulfill the query condition?

Re: Definition query not being honored

DorianneDysart — Wed, 19 Jun 2024 21:54:20 GMT

ditto

Strangely I was able to get it to work after I made a feature class copy of the layer and applied a definition query to the new layer. The original layer then updated.

The layer I was working with was actually a feature service, so I was not sure if there was a setting from the enterprise portal that was somehow overriding the definition query.

I am using ArcGIS Pro 3.0.2