Attribute Rule properties

Résumé

The Describe function returns the following properties for datasets that have attribute rules added to them.

Attribute rules can be added to a geodatabase feature class or table. The dataType returned is the dataType of the feature class or table.

Propriétés

Propriété	Explication	Type de données
batch (Lecture seule)	Indicates whether the rule is executed in batch mode. True—The rule is executed in batch mode. False—The rule is not executed in batch mode. Calculation rules may return either true or false, but constraint rules will always return false, and validation rules will always be true.	Boolean
checkParameters (Lecture seule)	A system-generated JSON value that defines the configuration of a Data Reviewer-based rule. Learn more about the available ArcGIS Data Reviewer checks	Object
creationTime (Lecture seule)	The date and time the attribute rule was created.	DateTime
description (Lecture seule)	The description of the attribute rule.	String
errorMessage (Lecture seule)	If the attribute rule has a custom error message (that is, constraint rules), this property will return the error message that was assigned for this rule.	String
errorNumber (Lecture seule)	If the attribute rule has a custom error number (that is, constraint rules), this property will return the error number that was assigned for this rule.	Long
evaluationOrder (Lecture seule)	If the rule type is calculation, this value gives the order that the rule is executed. The evaluation order is based on the order that the rule was added to the dataset. For example, if Rule A is added before Rule B, the evaluation number will be lower for Rule A.	Long
excludeFromClientEvaluation (Lecture seule)	Returns a Boolean describing whether the rule is excluded from client evaluation. True—The rule is excluded from client evaluation (server only). False—The rule is executed for all clients.	Boolean
fieldName (Lecture seule)	If the attribute rule is assigned to a field (that is, a calculation rule type), this property returns the field name.	String
id (Lecture seule)	Returns the rule ID as an integer value.	Integer
isEnabled (Lecture seule)	Returns a Boolean describing whether the rule is enabled. True—The rule is enabled and will be honored. False—The rule is disabled and will not be honored.	Boolean
name (Lecture seule)	The name of the attribute rule.	String
referencesExternalService (Lecture seule)	Indicates whether the rule references any external service.	Boolean
requiredGeodatabaseClientVersion (Lecture seule)	The required geodatabase client version is set per rule, depending on which Arcade functions are used in the script expression. For example, if the script includes the Sequence operation, a 10.6.1 geodatabase is required.	String
scriptExpression (Lecture seule)	The Arcade expression that defines the rule. Remarque : This property is not available for Data Reviewer rules.	String
severity (Lecture seule)	Defines the severity of the error. This property is applicable to validation rule types.	Integer
subtypeCode (Lecture seule)	If the attribute rule is assigned to a subtype, this property returns the subtype code to which it is assigned.	Long
tags (Lecture seule)	A set of tags that are used to identify the rule.	String
triggeringEvents (Lecture seule)	The triggering events defined in the attribute rule. For example, the rule may be triggered by Insert, Update, or Delete events during editing.	String
type (Lecture seule)	The type of the attribute rule. For example, a rule may be a calculation or constraint rule type.	String
userEditable (Lecture seule)	Returns a Boolean describing whether the rule allows editing of the attribute field that is being modified by the rule. True—Editors can edit the attribute values. False—Editors cannot edit the attribute values.	Boolean

Exemple de code

Attribute Rule properties example (stand-alone script)

The following stand-alone Python script prints a report of the attribute rule properties for a feature class.

# Import the required modules
import arcpy

# Path to the input feature class or table
fc = "C:\\MyProject\\MyDatabase.sde\\myGDB.USER1.Building"

# Print a report of the attribute rule properties
attRules = arcpy.Describe(fc).attributeRules
print("- Attribute Rule Properties -")

for ar in attRules:    
    if "Calculation" in ar.type:       
        print("- Calculation Rule:")
        print(" Name: {0}".format(ar.name))
        print(" Creation time: {0}".format(ar.creationTime))
        print(" Field: {0}".format(ar.fieldName))
        print(" Subtype code: {0}".format(ar.subtypeCode))
        print(" Description: {0}".format(ar.description))
        print(" Is editable: {0}".format(ar.userEditable))
        print(" Is enabled: {0}".format(ar.isEnabled))
        print(" Evaluation order: {0}".format(ar.evaluationOrder))
        print(" Exclude from client evaluation: {0}".format(ar.excludeFromClientEvaluation))
        print(" Triggering events: {0}".format(ar.triggeringEvents))
        print(" Script expression: {0} \n".format(ar.scriptExpression))
        print(" Is flagged as a batch rule: {0} \n".format(ar.batch))
        print(" Severity: {0} \n".format(ar.severity))
        print(" Tags: {0} \n".format(ar.tags))

    elif "Constraint" in ar.type:       
        print("- Constraint Rule:")
        print(" Name: {0}".format(ar.name))
        print(" Creation time: {0}".format(ar.creationTime))
        print(" Subtype code: {0}".format(ar.subtypeCode))
        print(" Description: {0}".format(ar.description))
        print(" Is editable: {0}".format(ar.userEditable))
        print(" Is enabled: {0}".format(ar.isEnabled))
        print(" Error number: {0}".format(ar.errorNumber))
        print(" Error message: {0}".format(ar.errorMessage))
        print(" Exclude from client evaluation: {0}".format(ar.excludeFromClientEvaluation))
        print(" Triggering events: {0}".format(ar.triggeringEvents))
        print(" Script expression: {0} \n".format(ar.scriptExpression))
        print(" Tags: {0} \n".format(ar.tags))

    elif "Validation" in ar.type:       
        print("- Validation Rule:")
        print(" Name: {0}".format(ar.name))
        print(" Creation time: {0}".format(ar.creationTime))
        print(" Subtype code: {0}".format(ar.subtypeCode))
        print(" Description: {0}".format(ar.description))
        print(" Is enabled: {0}".format(ar.isEnabled))
        print(" Error number: {0}".format(ar.errorNumber))
        print(" Error message: {0}".format(ar.errorMessage))
        print(" Script expression: {0} \n".format(ar.scriptExpression))
        print(" Is flagged as a batch rule: {0} \n".format(ar.batch))
        print(" Severity: {0} \n".format(ar.severity))
        print(" Tags: {0} \n".format(ar.tags))

Data Reviewer attribute rule properties example (stand-alone script)

The following stand-alone Python script prints a report of the check parameter properties of a Data Reviewer-generated attribute rule.

# Import the required modules
import arcpy

# Path to the input feature class or table
fc = "C:\\MyProject\\MyDatabase.sde\\myGDB.USER1.FacilitySite"

# Print a report of the checkParameter properties
attRules = arcpy.da.Describe(fc)['attributeRules']
for rule in range(len(attRules)):
    for key, value in attRules[rule]['checkParameters'].items():
        print("{}: {}".format(key, value))