Does Query Layer Honor Version Environment

98
3
Jump to solution
06-03-2022 10:02 AM
Labels (1)
AdamHinely
New Contributor II

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

0 Kudos
1 Solution

Accepted Solutions
George_Thompson
Esri Frequent Contributor

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

 

--- George T.

View solution in original post

3 Replies
George_Thompson
Esri Frequent Contributor

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

 

--- George T.
AdamHinely
New Contributor II

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

0 Kudos
George_Thompson
Esri Frequent Contributor

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

--- George T.
0 Kudos