Portal Hosted Feature Layer: Add Unique Constraint

[Blevins_Mark]

This article describes how you can add a unique constraint to a field of a hosted feature layer in AGOL. Is this functionality not present in Enterprise Portal? The edit button is not present when trying to add a unique constraint to a hosted feature layer field in enterprise.

[Rich]

I am experiencing the same issue. Is there any help available with this?

Thanks.

[GerberMatthew]

I am also experiencing the same issue.   The profile of the feature service is there on the portal item data page, but not editable.  I assumed it may need to be set on the publish side, but can not find the "Switch".

[GerberMatthew]

I think I have found a work around.

https://gis.stackexchange.com/questions/132530/enforcing-unique-values-in-field-when-editing-in-arcm...

The solution in this URL is the one posted by Farid.  Where an attribute index was created and the "Unique" checked.   I was able to successfully create a unique value over 2 attributes by adding both attributes into the "selected fields" the index was created on.

Eg.  I have 2 attributes "AdministrationArea" and "ObservationID"... ObservationID has to be unique per AdministrationArea.... but each AdministrationArea can each have an ObservationID which exists in another admin area.     

[Area A, ID = 1]

[Area A, ID = 2]

[Area B, ID = 1] 

I have not break tested this yet, but looks promising.  Using the smart editor widget in WAB returns the non-user friendly database error text to the user.   But at least the user is getting something to say "Hey your ID value already exists in the feature class"

[Sara_]

Hi

Are you able to provide screenshots what you did? I'm trying to follow. 

I'm trying to use this Unique Constraint functionality on Enterprise. We have samplers using Field Maps submitting duplicate QR codes. I'm also having this issue of no edit button, although it exists on AGOL. 

Thanks 

Sara

[GerberMatthew]

Hi Sara,

Right click the feature class and go to properties --> Indexes --> Click "Add" --> Give the index a name; Check the "Unique" check box; Select the attributes the accumulation/concatenation of their values need to be unique by --> Click OK.

I think this will only work when editing in "Online" mode where transactions are to the database.