Is globalID still the recommended primary key for relationship classes now that we can set a unique constraint on hosted layer fields?

873
2
06-13-2021 01:47 PM
lightpro
New Contributor III

Now that it's possible to set a unique value constraint on hosted feature layer fields is there anything which I should be aware of if I start to use fields other than globalid as primary keys in relationship classes? Being able to use string and number fields as keys would make reading related tables a lot easier. 

0 Kudos
2 Replies
jcarlson
MVP Esteemed Contributor

Interesting question! I'd like to see more development of relationships in AGOL in general.

However, there are some situations, like in Survey123, where parent globalID → child GUID is the only possible relationship that will function properly in the app. It wouldn't surprise me to find other cases throughout the AGOL system that assume a similar relate.

Honestly, you might post this same thing in the AGOL Ideas exchange, as it's a nice idea. I have a few use-cases that it would work for, and I'd up-vote the idea.

- Josh Carlson
Kendall County GIS
lightpro
New Contributor III

I've cross-posted this to ideas if you want to upvote! https://community.esri.com/t5/arcgis-online-ideas/agol-unique-constraint-for-relationship-classes/id...

Good to know about potential Survey123 issues. I don't really use it but might for my upcoming project!

 

0 Kudos