Does SQL View provide updated data & include changes which are made(committed) in Pro but not yet saved?

AnkushMadankar — Tue, 19 Dec 2023 04:46:25 GMT

I have Enterpriser SQL Sever Connection as Geodatabase (ArcGIS PRO 3.1). This database has SQL View with few joins. I am using this view to load data in lookup/dropdown. I have few issues related to data been fetch and displayed after few edits been made to map until user save the edits. I suspect SQL View does not provide updated data from joined table which are been edited but not saved, whereas individual table provide updated edit data.

Sample code:

var queryTableDescription = new QueryTableDescription(new QueryDef { Tables = "ViewName"} ); var queryTable = geodatabase.OpenQueryTable(queryTableDescription); var data = queryTable.Search();

Please anyone could confirm this behaviour?

Thanks in advance!

topic Does SQL View provide updated data & include changes which are made(committed) in Pro but not yet saved? in ArcGIS Pro Questions

Does SQL View provide updated data & include changes which are made(committed) in Pro but not yet saved?