Latest Contributions by JohannesLindner

Something like this?   // label value var x = 11.8643 // number of subscripted digits var digits = 1 // integer part var x_int = Floor(x) // decimal part var x_dec = (x - x_int) * Pow(10, digits) x_dec = Round(x_dec, 0) // put it all together return x_int + '_{' + x_dec + '}'   ... View more

Something like this? var related_records = FeatureSetByRelationshipName($feature, "MonitoringPhotoSites") var cnt = 0 for(var rr in related_records) { cnt += Count(Attachments(rr)) } return cnt ... View more

If you know the query names, you can do something like this:   def change_definition_query(layer, query_name): """Changes the definition query of a layer in ArcGIS Pro. layer: arcpy.mp.Layer object, the layer that the query will be assigned to query_name: str, the name of the query that is assigned to the layer The query has to exist in the layer. If it doesn't, this function throws a ValueError. Calling this function with query_name=None will remove the active query. """ cim = lyr.getDefinition('V2') query = None if query_name is not None: queries = cim.featureTable.definitionFilterChoices try: query = {q.name: q.definitionExpression for q in queries}[query_name] except KeyError: raise ValueError("Query '{}' not found!".format(query_name)) from None cim.featureTable.definitionExpression = query cim.featureTable.definitionExpressionName = query_name layer.setDefinition(cim) lyr = arcpy.mp.ArcGISProject("current").activeMap.listLayers("Layer")[0] change_definition_query(lyr, "Query 1") change_definition_query(lyr, "DistanceNotNull") change_definition_query(lyr, None) change_definition_query(lyr, "ThisWillThrowAnError")   ... View more

According to the documentation of the attribute rule dicitonary keywords , the "result" field in the returned dictionary is either a value for the field definied as return field for the rule a dicitionary for the geometry and/or attributes of the feature, if you haven't set a return field in the rule You return a log message. If you haven't set a text field as output field of the rule, this should throw an error. The ObjectID in the update array should be given in the dictionary field "objectID", not "OBJECTID", don't know if this would cause an error, though.   So, try this: //s1 - get all the features from sewer upgrades feature class // you only need DBNUMBER (to filter) and OBJECTID (to send edits) var destination = FeatureSetByName($datastore, "GEO_DB.ENG_SD.SewerUpgrade", ["DBNUMBER","OBJECTID"], false); //s2 - get dbnumber edited in the projects developments feature class var dbnumber = $feature.DBNUMBER; //s3 - filter feature based on the existing edit var match = Filter(destination, "DBNUMBER = @dbnumber"); //s4 - update records in sewer upgrades var sewerupgradelist = []; var counter = 0; for (var feature in match) { sewerupgradelist[counter] = { 'objectID' : feature.OBJECTID, 'attributes' : { 'CONS_ST' : $feature.CONS_ST, 'CONS_ED' : $feature.CONS_ED, 'EST_CON_DUR' : $feature.EST_CONS_DUR, 'TECH_REV' : $feature.TECH_REV, 'STATUS' : $feature.STATUS } } counter++ } return { // only use this if you have set a text field as return field for the rule // 'result' : numfeatures + ' sewer upgrades features found.', 'edit' : [{ 'className' : "GEO_DB.ENG_SD.SewerUpgrade", 'updates' : sewerupgradelist }] }     ... View more