topic Re: Attribute rules for enforcing attachments? in ArcGIS Pro Questions

Attribute rules for enforcing attachments?

AndrewZimba1 — Mon, 27 Jan 2020 12:27:07 GMT

When building services for Collector with feature classes in an enterprise gdb, are attribute rules the appropriate mechanism for enforcing the inclusion of a .jpg attachment to a point and returning an error message if a save attempt is made without such an attachment?

Re: Attribute rules for enforcing attachments?

HusseinNasser2 — Sat, 11 Dec 2021 08:35:44 GMT

Attribute rule is one way to enforce this. You should be able to add a constraint rule to the attachments table of your class that prevents adding a row to the attachment table if the extension is not jpg. You could then publish the class as a feature service to ArcGIS Enterprise and consume it from collector. (Attribute rules not supported on ArcGIS Online yet)

Here is an example

Here is an example script

//if the extension is jpg allow the edit, else don't allow the edit. 
if (right($feature.ATT_NAME, 3) == "jpg") return true

return false‍‍‍‍

The attachment will only be added if the file has a `jpg` extension. There might be a bug where you won't get a meaningful error message back today. We might be able to get to that in the future where the actual error message comes back.

Re: Attribute rules for enforcing attachments?

AndrewZimba1 — Tue, 28 Jan 2020 13:17:53 GMT

Right on. Now it seems that will enforce the attachment type, but it won't enforce that a point must have an attachment, right?

Re: Attribute rules for enforcing attachments?

XanderBakker — Tue, 28 Jan 2020 14:46:12 GMT

Hi Andrew Zimba ,

Arcade provides the Attachments function which will return an array of the Attachment types. The problem is that these functions and types are not available in the Attribute rule profile (yet?). Normally you would do a Count and if the count is larger than 0, you could check the content type.

There might be a way using a FeatureSetBy* in combination with Filter to get to the result, but it would be better to have the Attachments function and Attachment type available in the attribute rule profiles.

HNasser-esristaff ; any idea if that is on the roadmap?

Re: Attribute rules for enforcing attachments?

XanderBakker — Tue, 28 Jan 2020 14:54:07 GMT

There is an example attribute rule (constraint) here by mmiller-esristaff that could help get started:

arcade-expressions/reject_too_many_related.md at master · MikeMillerGIS/arcade-expressions · GitHub

Re: Attribute rules for enforcing attachments?

AndrewZimba1 — Tue, 28 Jan 2020 15:49:15 GMT

I'll check it out. Thanks!

Re: Attribute rules for enforcing attachments?

HusseinNasser2 — Tue, 28 Jan 2020 16:49:33 GMT

Thanks Xander!

The Attachments arcade function is actually supported on the Attribute Rules profile, we will just need to update the documentation to reflect that. Good find! So yes one can prevent a feature from being created/updated if no attachments was found. However I see this rule fits more as Validation rule instead of a constraint rule (Generating errors for existing features with no attachments)

Re: Attribute rules for enforcing attachments?

AndrewZimba1 — Tue, 28 Jan 2020 19:16:03 GMT

Something here I'm not getting. I'm attempting to implement as a Validation rule. Here's the rule setup:

On save it throws Error 001946: The input workspace type must be branch version.

Not sure what is going on here.

Re: Attribute rules for enforcing attachments?

XanderBakker — Sat, 11 Dec 2021 08:35:47 GMT

Hi Andrew Zimba ,

Not sure if branch versioning is required to implement this type of attribute rule. Hussein Nasser ; can you confirm?

What you do need to know is that you should check using "count" and not comparing it to null. If you do not have attachments, it will return an array with no items, yet it will not be null.

Since you want to check for jpg attachments, see the example below that will only check this content type and in this example I also check for the images size between 1M and 5M bytes.

var options = {"types": ["image/jpeg"],
               "minsize": 1000000,
               "maxsize": 5000000}
var atts = Attachments($feature, options);
if (Count(atts)==0) {
    return false;
} else {
    return true;
}
‍‍‍‍‍‍‍‍‍

Re: Attribute rules for enforcing attachments?

HusseinNasser2 — Thu, 30 Jan 2020 15:58:06 GMT

Apologies I should have mentioned that and Thanks Xander Bakker‌ for reminding me. Yes Validation and Batch Calculation rule are only supported Enterprise Geodatabase Datasets registered with branched versioned. We are bringing the support of File Geodatabase to these type of rules in the upcoming releases soon.

Re: Attribute rules for enforcing attachments?

XanderBakker — Thu, 30 Jan 2020 16:17:08 GMT

Thanks Hussein Nasser for clarifying this. I was aware of the requirement of the EGDB but not of the part that branch versioning was required. Good to know!

Will you be at the distributor UN workshop next week in Redlands? If so, see you there.

Re: Attribute rules for enforcing attachments?

AndrewZimba1 — Thu, 30 Jan 2020 16:22:06 GMT

One more question about attribute rules in general - will they work in collector when using it in offline mode?

Re: Attribute rules for enforcing attachments?

HusseinNasser2 — Thu, 30 Jan 2020 18:18:11 GMT

No they will not work in Collector in offline mode, that is because when we download the data offline the Attribute Rules are not coming back with the data. They will only work on online mode and will be triggered on the server side.

In the future releases we will have the capability for Collector and other ArcGIS Runtime applications to download Attribute Rules and execute them locally offline. It is a big project that is in the works

Re: Attribute rules for enforcing attachments?

geopamplona — Wed, 10 Jan 2024 11:54:28 GMT

Hi @HusseinNasser2

I am using the code that was shared here but I got an unexpected error:

I get the following error
invalid arcade expression, arcade error: expected attachment type, script line: 4

My attribute rule:

var features = FeatureSetByName($datastore,'SewerLine', ['*'], false);
var gid=$feature.REL_GLOBALID;
var item=First(Filter(features, 'globalid = @gid'));
var count = Count(Attachments(item));
if ($editcontext.editType == 'DELETE'){
var count_total=count-1
} else {
var count_total=count
}

return {
'edit': [{
'classname' : 'SewerLine',
'updates' : [{
'globalid': gid,
'attributes' : {'NumAdjuntos' :count_total }
}]
}]
}

I have tried the same Count(Attachments()) line and it is valid arcade for calculated fields.

I'm using ArCGIS pro 2.9.11 and enterprise 2.9.1

Thanks!