nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Definition query not being honored

JoeBorgione

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....

Trouver plus de publications taguées avec

Analysis

Content Management

Desktop

Accepted answers

Wolf

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'?

All comments

DorianneDysart

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

Wolf

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?

BrettJenkinson

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.

JoeBorgione

OMG that's embarassing.... 😖

Wolf

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.