Latest Contributions by ChristopherBowering

I have a feature class related to Table 1 (for illustration purposes) then Table 1 is related to Table 2.  The relationship classes are both based on GlobalID to GUID...all datasets are in an SDE environment.  Each of the 3 datasets contains the identical field 'Assembly_ID'.   I want the 'Assembly_ID' value to be updated in Table 2 when the feature class field is updated.  Currently, I have a functional attribute rule that will update the 'Assembly_ID' field in Table 1 when said field in the feature class is updated.  I have another functional rule that will update the 'Assembly_ID' field in Table 2 from said field in Table 1 when some other field is updated in Table 1.  I don't want to have to perform an edit/update in Table 1 for the value to pass thru to Table 2.   Is there a way to pass the value directly from the feature class to Table 2 (I DO NOT want to create a relationship between the feature class and Table 2...that field is the only common field between the feature class and Table 2) OR have the value pass from Table 1 to Table 2, passively, without some trigger being activated in Table 1? ... View more

I am wondering if there is a way to locate all attribute rules present in an Enterprise SQL Geodatabase thru queries in SQL Server Management Studio? Currently, the only way I know how to view an attribute rule in SQL is looking at the definition column within the GDB_ITEMS list. However, you must already know which feature class/table to look at. I would like to be able to view a quick inventory of all attribute rules present in a geodatabase thru a single query of some sort. Is this possible? ... View more

I have a basic AR that updates the value in a child table field when the corresponding parent field is updated (Enterprise Geodatabase...GlobalID to GUID relationship).  When this is the only AR enabled, everything works as it should.  However, when used in conjunction with another AR set on the child table, I receive the error "The evaluation of attribute rules is cyclic or exceeds maximum cascading level" when I update the parent field value. Note:  The 2 rules I'm using in conjunction do not use any of the same fields See the code below.  Any help would be greatly appreciated! @JohannesLindner @HusseinNasser2    if ($originalfeature.PARENT FIELD == $feature.PARENT FIELD) { return } var fs = FeatureSetByRelationshipName($feature, "RELATIONSHIP CLASS"); var updates = [] for(var f in fs) { if(f.GlobalID == $feature.GlobalID) { continue } var u = { globalID: f.GlobalID, attributes: { "CHILD FIELD": $feature.PARENT FIELD } } Push(updates, u) } return { edit: [{ className: "CHILD TABLE NAME", updates: updates }] }   ... View more