Does Query Layer Honor Version Environment

[AdamHinely]

Hello,

What table

Does a query layer of a versioned enterprise geodatabase in ArcGIS Pro query the base table or the version specified in the database source configuration?

Since query layers are used in Esri software, I am hoping that they honor the version, but the results of my query layer show otherwise.

Thanks,

Adam

[George_Thompson · Accepted solution]

I am not sure 100%, but would lean towards it just queries the base table. This is based on it "directly" connecting to the database or cloud datastore and reading the information directly.

The closest doc stating something close is this:

Query layers that access geodatabase system tables are not supported.

---

https://pro.arcgis.com/en/pro-app/latest/help/mapping/layer-properties/creating-a-query-layer.htm

https://pro.arcgis.com/en/pro-app/latest/help/mapping/layer-properties/what-is-a-query-layer-.htm

[AdamHinely]

Thanks George. That is what I suspected. It would be nice if the language in those articles could be straight forward to this point.

Adam

[George_Thompson]

You can provide feedback on the help topic at the bottom. They do take a look at those comments.