AnsweredAssumed Answered

ArcMap Query Layer results do not match ArcSDE Table or SMSS SDE Table View

Question asked by rralbritton on Jun 13, 2017
Latest reply on Jun 13, 2017 by rralbritton

I am working in a versioned database (SQL Server 2012, ArcMap 10.4). When I view the table in ArcMap or Catalog I see 17 rows of data. When I create a query layer based on this table, it returns 15 rows of data AND the data that it returns is old data. Specifically, its returning 1 row of data that has been removed, and is not returning 3 new rows of data that have been created. The table with the correct data is the same database and version that I am creating the query layers against.

 

Correct Data: Connected to the database with transaction version 'Edits'

 

 

Incorrect Data and Inputs:

Connected to the same database inwhich the properties of that DB are set to point to the 'Edits' version.

NOTE: I have also done the query so that the table name is appended with the view (uusd.dbo.das_antenna_info_evw) and I get the same results. I have also tried creating the query layer by going to File > Add Data > Add Query Layer

 

 

If I go into SMSS and query the table view (table_name_evw) I get the correct records back, but if I query table directly I get the incorrect results - the results that I'm getting back with the query layer

 

Whats going on here?

Outcomes