topic Re: Does Query Layer Honor Version Environment in Data Management Questions

Does Query Layer Honor Version Environment

AdamHinely — Fri, 03 Jun 2022 17:02:26 GMT

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

Re: Does Query Layer Honor Version Environment

George_Thompson — Fri, 03 Jun 2022 17:13:04 GMT

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

Re: Does Query Layer Honor Version Environment

AdamHinely — Fri, 03 Jun 2022 17:39:21 GMT

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

Re: Does Query Layer Honor Version Environment

George_Thompson — Fri, 03 Jun 2022 19:11:06 GMT

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