I am looking for a way to set the version that a tables versioned view uses when referenced inside ArcMap 10.3 with a query layer. In sql I can use the following to return records only visible to the version specified in line 1.
EXEC sde.version_util.set_current_version('user.version_name'); select * from user.sometable_evw;
When a query layer is added into ArcMap, the table of contents shows it as referencing the version set in the sde connection file. In my testing I have found that even though the layer falls under the version you may want, it is only reading rows referenced in the default version.
Does anyone know if there is another way to set the version the view is using?