Table joins while using branched versioning

402
3
05-11-2022 01:07 PM
RussellAuwae
New Contributor II

Are table joins not allowed on branched versioned data? I keep getting a user permission error on both the version I created and the DEFAULT, and I'm the data owner. I think my best option at this point is to download the layer, perform the join, and then publish and version it again. Versioning seems like it has it's limitations, and really just for basic editing work. 

0 Kudos
3 Replies
George_Thompson
Esri Frequent Contributor

Once you branch version data (and publish as a service) you cannot connect directly to the feature classes in the Enterprise Geodatabase. So I do not think the join would work there, you may be able to join to the feature service.

--- George T.
0 Kudos
jcarlson
MVP Esteemed Contributor

What is it you're trying to do, exactly? If you write your SQL carefully, it's possible to use a Query Layer against branch versioned data.

- Josh Carlson
Kendall County GIS
0 Kudos
KevinWyckoff1
New Contributor III

I am curious if anyone ever found a solution to this? I have a feature service purpose built for editing branch versioned data, and when I just attempted to join I got this same insufficient permissions error.

0 Kudos