topic Set ValidationStatus column value in calculation rule in Attribute Rules Questions

Set ValidationStatus column value in calculation rule

mohanprajapati — Mon, 17 Jun 2024 18:14:46 GMT

I want to modify the validationstatus column to 0 when the Python program inserts/updates/deletes the record. I tried to modify the validationstatus column' value using the result and edit parameters of calculation attribute rules. However, validationstatus column is not editable using this way.

My main objective is to set validationstatus column's value to 0 when the record is inserted using Python program.

Could you please share other options to do it?

Re: Set ValidationStatus column value in calculation rule

MikeMillerGIS — Mon, 17 Jun 2024 19:41:04 GMT

I do not think you can set that column to 0. When a row is inserted, it will require calculation and validation. To set that bit, you can use the the calculationRequired/validationRequired keyword. I do not see an option to say calculation/validation not required.

https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/attribute-rule-dictionary-keywords.htm#ESRI_SECTION1_4DC091DA6F984FB1BB03722FA6B48FE3

Re: Set ValidationStatus column value in calculation rule

mohanprajapati — Mon, 17 Jun 2024 21:10:12 GMT

Hi Mike!

I tried to validationRequired. This table (TableName) has validation rule. It does not trigger the validation rule.

# Validation Required
var feature_check = FeatureSetByName($datastore, "TableName",['GlobalID'], false);
var dict_cur_user = GetUser(feature_check);
var cur_user = Upper(Trim(dict_cur_user.username));
// we only need to update if user is USER1.
Console($feature.VALIDATIONSTATUS);
if (cur_user == 'USER1')
{
return {
'validationRequired': [{
'className': 'TableName',
'GlobalIDs': [$feature.GlobalID]
}]
} // close return
} // close main if

Re: Set ValidationStatus column value in calculation rule

MikeMillerGIS — Tue, 18 Jun 2024 12:08:14 GMT

This value is just a flag set on the row so that the batch validation process knows to validate it. You have to manually trigger the batch process. You can use the Error Inspector window in ArcGIS Pro or the Evaluate Rules GP tool.

Re: Set ValidationStatus column value in calculation rule

mohanprajapati — Tue, 18 Jun 2024 19:18:30 GMT

I use Arcpy to insert/update/delete records into the table feature. So according to https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/evaluate-rules.htm how can I use the extent parameter to pass only selected records and the version name? (It may take the current version I guess).