Latest Contributions by BlakeTerhune

The conditions are evaluated in order so put the most important one first and use elif for the other conditions. You'll also need to update the parameters in your function to accept Field2. # Expression Reclass(!Field1!, !Field2!) # Code Block def Reclass(field1, field2): if field2 == "y": return "4" elif field1=="x": return "1" elif field1 =="y": return "2" else: return "3"   ... View more

You can use an f-string to dynamically insert the field name into the calculate field expression. fields = arcpy.ListFields("perc_test_table") for field in fields: if field.name not in ['OBJECTID', 'Shape_Length', 'Shape_Area', 'SumField', 'Spatial_ID']: arcpy.management.CalculateField(table, f"{field.name}_perc", f"!{field.name}!/!SumField!", "PYTHON3", field_type="DOUBLE")   ... View more

Some of these topics would make some interesting blog articles, @HaydenWelch. Hopefully you'll consider sharing your methods with the world. ... View more

The final solution must not use arcpy at all? What format is your source data in and what format do you need the output in? ... View more

This is what I do and it seems to work. Maybe you're just missing clearMessage()   def updateParameters(self, parameters): """Modify the values and properties of parameters before internal validation is performed. This method is called whenever a parameter has been changed.""" project_id = parameters[0].valueAsText valid_project_ids = ['123', '456', '789'] error_msg = f'Unrecognized project ID; please enter one of the following: {valid_project_ids}' if project_id: if project_id not in valid_project_ids: project_id.setErrorMessage(error_msg) else: project_id.clearMessage() else: project_id.setErrorMessage(error_msg) return   ... View more

Thanks for chiming in, @David_Lindsey! Seeing as I'm on Pro 3.1.3, it makes sense that I am not able to replicate the issue. Looking forward to your results with Pro 3.3. ... View more

@JamesMorrison1 wrote: Could it be related to how Python converts the value 1040058 to a string?  That doesn't seem reasonable to me, but you can test that with print(sdeReturn) before you do all that parsing and formatting. ... View more

I tested your code in SQL Developer (Oracle 19c) and in Python (ArcGIS Pro 3.1.3) and the SDE_ID value is the same both times: the correct (non-negative) id. ... View more

The latest on this is to expect it in the June release. ... View more

Since you are choosing a layer as your input parameter, there's no need to get the layer from the Project again. def UpdateSymbology(): # To allow overwriting outputs change overwriteOutput option to True. arcpy.env.overwriteOutput = True # Model Environment Setting Projects_Layer = arcpy.GetParameter(0) # Input parameter # ... rest of the code ... ... View more

Looking at the documentation, the sample code does not use the output layer for anything. Try without chaining the outputs, only use the input layer. import arcpy def UpdateSymbology(): # To allow overwriting outputs change overwriteOutput option to True. arcpy.env.overwriteOutput = True # Model Environment Setting aprx = arcpy.mp.ArcGISProject("CURRENT") mp = aprx.activeMap Projects = arcpy.GetParameterAsText(0) # Input parameter Projects_Layer = mp.listLayers(Projects)[0] # Process: Add Field to Projects layer that is Date Only type (Add Field) (management) arcpy.management.AddField( in_table=Projects_Layer, field_name="Date", field_type="DATEONLY", field_alias="Date" ) # Process: Calculate added Date Only field equal to the exisiting 'Start Date' text field (Calculate Field) (management) arcpy.management.CalculateField(in_table=Projects_Layer, field="Date", expression="!Start_Date!") # Process: Select Layer By Date And Time (Select Layer By Date And Time) (ca) arcpy.ca.SelectLayerByDateAndTime( in_layer_or_view=Projects_Layer, selection_type="NEW_SELECTION", time_type="SINGLE_TIME_FIELD", date_field="Date", selection_options=["DATE"], date_selection_type="DATE_RANGE", start_date=StartDate, end_date=EndDate ) # Process: Calculate Field with Selection to "Beyond 90" (Calculate Field) (management) arcpy.management.CalculateField(in_table=Projects_Layer, field="Symbology", expression="Beyond 90") if __name__ == '__main__': UpdateSymbology() print("FIN") ... View more

In this latest code, StartDate and EndDate are undefined when you call them in SelectLayerByDateAndTime(). ... View more

On line 8 where you're creating the fields list, the last part where it's checking if f.name in ('Name') seems weird. Are you intending to only make a list with exactly one value of 'Name'? As-is, I think like 8 is actually only getting fields that are "N", "a", "m", "e". If you are wanting to check equality, use an equals: fields = [f.name for f in arcpy.ListFields(fc) if f.name = 'Name'] If you are wanting to check equality on a number of possible matches, then that tuple needs a comma after the first item: fields = [f.name for f in arcpy.ListFields(fc) if f.name in ('Name',)]  Or just use a list instead of a tuple: fields = [f.name for f in arcpy.ListFields(fc) if f.name in ['Name']] ... View more

This is likely the issue. The other way to accidentally use the feature class instead of the layer is when choosing the value in the parameter at run time of the script tool. I'm assuming you have a parameter for "Project_Layer". If you're browsing to the feature class in a geodatabase for this parameter instead of choosing it from the list of layers in the map, then it'll calculate on all records (without the selection). Also, if you have the same feature class added to the map in more than one layer and you choose the wrong one (without a selection), it will calculate on all records. So there's multiple ways to mess this up. It might be worth adding some validation in your script tool to check if the layer has a selection. You can use the getSelectionSet() method on the Layer object. ... View more