Layer Definition Query - When does it update?

[sdavidson]

Using ArcGIS Pro - Connected to enterprise database, and the featureclass is in the enterprise database.

When does a definition query on a layer update? I have two versions of the same featureclass in a map: one layer has a definition query and the other does not.

• The definition query is used to show/find locations where a field was not properly filled in during feature creation. The symbology on this layer is fairly basic (literally just purple lines). The definition query is "if field x is null".
• The other layer is the same, but no definition query and the symbology is more complex. Updates are completed on this layer. Specifically updating field 'x' identified through the definition query in the other layer.

After completing an edit on the non-definition query layer (on the field the definition query is looking for) the definition query layer doesn't update. However, when restarting ArcGIS Pro the layer updates. Is there a way to update the layer without restarting the entire program?

What I've tried:

• Refreshing the map.
• Refreshing the definition query layer attribute table.
• Creating a second definition query and switching between them.
• Googled definition query and could not find when and how the table is updated.

Happy to provide additional information; please be specific.

[DanPatterson]

I tend not to use definition queries, but sometimes display filters,

Use display filters—ArcGIS Pro | Documentation

however, there is a toggle for layers (layer properties, general) which is off by default, toggle it on for a suitable time interval and see if it has any effect

[clt_cabq]

I've used similar approach to what you describe - I think what you are looking for is the refresh button down in the lower right part of the map window - after you have made updates, hit that and it should refresh all layers in your map, this has always worked for me. 

[sdavidson]

Hi clt_cabq,

Thank you for the kind reply. This is one of the solutions I tried, described in my first post, and it is not working. Appreciate the suggestion.

[Bud]

I’m surprised refreshing doesn’t work.

Could you show us a screen recording video using a program like ScreenToGIF? You can use the portable version is you don’t have Windows Admin Privileges. If your data is sensitive, you could create dummy data for the purpose of the video.

Other questions:

1. What kind of enterprise geodatabase? Oracle 18c?
2. What version of ArcGIS Pro?
3. Are you manually saving your edits before refreshing?
4. What are your editing settings? Saving automatically, etc.
5. Can you show us a video of a simplified workflow from scratch? Create a new map with new simplified dummy data. Sometimes starting from scratch like that can help identify the issue.