Query layer support?

Discussion created by trevor_hart-eagle-co-nz-esridist on May 30, 2012
Latest reply on Feb 11, 2015 by alison_ott
We have an Job MXD which contains a query layer.

When the MXD data sources are remapped (to the Job version) the query layer reverts back to the base feature class rather than alter the query layer.

For example my query layer contains 1 feature class plus 2 tables combined via joins. When the MXD is remapped all I get is my feature class. In this case I actually get errors as the label expression comes from one of the tables.

Is this normal behaviour? This suggest to me that query layers are really supported?

EDIT BTW simple querying a single table or view works fine, so if I combine the above query into a view and use that for the query layer defintion it appears to work fine.