Select to view content in your preferred language

When updating layer source, update definition query SQL values

258
0
06-21-2023 08:47 AM
Status: Open
Labels (1)
wayfaringrob
Frequent Contributor II

When updating a data source, update the fields and values shown in the definition query builder. For example, we just got a new urban area layer within the last year, and it will need to be updated in many maps this year. However, our old query won't work (there's even a warning upon switching the source):

rburke_0-1687362175442.png

But when I go to the definition query tab to do what should be a quick update, I'm still greeted with the old fields list.

rburke_1-1687362204380.png

This persists even if I add a new definition query.

rburke_2-1687362245255.png

I have to click OK, reopen layer properties, and start all over again or edit in SQL.

rburke_3-1687362273587.png

rburke_4-1687362292555.png

I would really like if it were less aggressive about pushing you into SQL-only mode and just let you update the field without all the hassle. In this case, it's only the field that is changed, and there are other areas of the application, such as geoprocessing, that display a error or warning rather than forcing you into, say, Python, when an invalid parameter is found.