Select to view content in your preferred language

Allow Registered Database Views As the Destination Table in Relationship Classes

1005
3
10-28-2021 12:02 PM
Status: Open
Labels (1)
DavidSolari
Occasional Contributor III

Allow the Destination table in a relationship class to be a registered database view. The relationship wouldn't support any features that a view would prohibit (no composite relationships, no message passing etc.) but could be used to link database view records to a parent feature or record in apps such as Field Maps.

The main use of this feature in my organization would be to create a view of an entire archive table or branch versioned table in the EGDB, register that view, then allow users to jump to a list of archived records directly from a feature in various apps. To my knowledge there is no consistent method of relating data in ArcGIS without a relationship class in the database and this seems more pragmatic than defining a new relationship type at the Server/AGOL/Enterprise level.

3 Comments
ThomasJurk

The Support for creating Relationship Classes on registred Database Views was dropped in ArcGIS > 10.2.2. Please reactivate this Functionality in future Releases of ArcGIS.

AdamStewart

There is so much Esri functionality that needs to support database views.  This is one of those things.

GillesLavandier

We absolutely need this in order to not having to write view content back to a physical table.