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; } } }

ArcGIS Pro spatial view column not found after adding it in SQL Server

PLadd

I have a spatial view created in SQL Server. Works fine in ArcGIS Pro. HOWEVER, if I add a new field to the table "joined" in the spatial view in SQL Server, that new field does not appear in ArcGIS Pro where the spatial view is in use. If I re-add the spatial view, it shows the new field. But I can't do this because I have dozens of expressions and HTML in the popup and I'll lose a lot of work. I tried closing and re-opening - nothing. I tried refreshing the data in the "List by data Source" in the TOC and Refreshing the geodatabase connection.

Anybody have any tricks to get the new field to display in an existing spatial view layer in ArcGIS Pro?

タグ付けされた投稿をもっと見る

Geodatabase

Accepted answers

Robert LeClair

If you go into the Layer Properties for the existing database view, you should be able to go into the properties to update the view definition to include the new field.

All comments

Robert LeClair

Certainly! Happy to assist. You are correct that updating the SQL in SQL Server Management Studio does not update the Database View in ArcGIS Pro. The DB view is stored in the eGDB. The workflow you described in your response is correct as well. I'm glad it worked out! Have a great weekend!

PLadd

Thanks @Robert_LeClair for the response and the help (and for the link). I guess I was expecting that if I changed the spatial query in SQL Server and then refreshed/reopened in ArcGIS Pro, the new spatial query would get pulled through. It seems it doesn't work that way.

Just to expand on your instructions, I went to the layer properties, clicked on Source, then clicked on the edit icon for Query (see image below). In the Query window I can double click on the fields to be added (then add commas of course). I guess I could also copy/paste the query from SQL Server. Thanks again for helping me out.

Robert LeClair

If you go into the Layer Properties for the existing database view, you should be able to go into the properties to update the view definition to include the new field.

会話に参加する

サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。

クイックリンク

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