nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Find more posts tagged with

Geodatabase

Accepted answers

George_Thompson

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

All comments

George_Thompson

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

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

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

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.