Query Layer and Database state ID's

Discussion created by dpbamford1 on Jan 7, 2013
Latest reply on Jan 7, 2013 by jskinner-esristaff

I am trying to create a query layer on a sql server feature class. The query layer is created but does not include features I have recently added. The version for these edits has been reconciled, posted and deleted and the dastabase compressed but the query layer does not show the new features I have added. There are other versions open but it is difficult for us to get our databases back to 0. Is there a way to query a particular version state (i.e. sde.default not state 0)? Or is there a way I can get these new features into a query layer?