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!