Latest Contributions by JimWilliams

Hello, I am looking to return the last feature in a feature set. I can do this with the first record in a feature set, but I am unsure how to return other features from the feature set. Like the second record in a feature set.      var manholes = FeatureSetByName($datastore, 'Nodes', ['IN_1_EL'], true) var intersecting = Intersects($feature, manholes) var count_check = Count(intersecting) if (count_check > 0) { return first(intersecting).IN_1_EL } else { return $feature.Down_Inv }       Anyone know how to access the second value in a feature set? Regards, Jim ... View more

Hello, A user has deleted some data. The current feature class has archiving enabled. I can find the data in the Archived class, but I am unsure how to go about updating the record so it can be marked as current. In theory I can do this by updating the GDB_TO_DATE to mm/dd/9999. Which should mark the record as the most recent record. First can you edit the data in an archived feature class? Second is there a tool or a built in process to "recover" the deleted records? Regards, Jim ... View more

Hello, I am looking to do a one-way replication, we currently have just Archiving enabled for all the feature classes/tables and they all have GlobalIDs. This is going from a SDE SQL database to a file geodatabase.I keep getting a "ERROR 000769: cant create replica because none of the data can be replicated." Is this because you have to have versioning enabled? The documentation is not very clear it makes it sound like you can do one-way replicas with only archiving enabled? regards, Jim   ... View more

Hello, I am stuck here. I need to filter a feature set by a date a value. I set up this up but on lie 7 for the "cnt" variable I am getting "Failed to Query statistics", but If I pull out the "AND MMS_Date_Turning >= @current_year" section from my filter it works fine.  This query fails: var quad = $feature.Quadrant; if ($feature.Quadrant != null) { var current_year = Date(Year(Now()),0,1) var System_valve_set = filter(featuresetbyname($datastore, 'sValve', ['OBJECTID', 'WATERVALVETURNING_STATUS', 'GRID_NUM', 'MMS_Date_Turning'], false), "GRID_NUM = @quad AND MMS_Date_Turning >= @current_year") var cnt = count(System_valve_set); if (cnt > 0 ) { var query = "WATERVALVETURNING_STATUS = 'Closed'" var System_closed_valve_set = filter(System_valve_set, query) var closed_cnt = count(System_closed_valve_set) if (closed_cnt > 0){ return count(System_valve_set) - count(System_closed_valve_set) } else {return count(System_valve_set)} } else { return null } } else { return null } This query works: var quad = $feature.Quadrant; if ($feature.Quadrant != null) { var current_year = Date(Year(Now()),0,1) var System_valve_set = filter(featuresetbyname($datastore, 'sValve', ['OBJECTID', 'WATERVALVETURNING_STATUS', 'GRID_NUM', 'MMS_Date_Turning'], false), "GRID_NUM = @quad") var cnt = count(System_valve_set); if (cnt > 0 ) { var query = "WATERVALVETURNING_STATUS = 'Closed'" var System_closed_valve_set = filter(System_valve_set, query) var closed_cnt = count(System_closed_valve_set) if (closed_cnt > 0){ return count(System_valve_set) - count(System_closed_valve_set) } else {return count(System_valve_set)} } else { return null } } else { return null }   Regards,  Jim ... View more

Hello, I see there are a few other questions about his error, but I didn't see anything telling me what the really is causing the issues here. I am using a view in a attribute rule to get a feature set that I use a filter on to get a subset.  Can I use a view in a attribute rule, or does featuresetbyname work for a view?  What does "Class was not Found%s" mean? Is this a feature class that is not found, are there null values in the attribute rule?  var quad = $feature.Quadrant; if ($feature.Quadrant != null) { var System_valve_set = filter(featuresetbyname($datastore, 'Valve', ['OBJECTID', 'WATERVALVETURNING_STATUS', 'GRID_NUM'], true), Concatenate(["GRID_NUM = ", quad], '')) var Valves_Exercised_This_Year = filter(featuresetbyname($datastore, 'Valve_Exercised_This_Year', ['OBJECTID', 'Status', 'GRID_NUM'], true), Concatenate(["GRID_NUM = ", quad], '')) var cnt = count(System_valve_set) // make the query for each possible situation where there could be a feature set that is null if (Valves_Exercised_This_Year != null && cnt > 0) { var query = "Status = 'Closed'" var System_closed_valve_set = filter(Valves_Exercised_This_Year, query) var result = count(System_valve_set) - count(System_closed_valve_set) return result } else { return null } } else { return null } regards,  Jim ... View more