Refresh Data after Python Tool Execution

Question

By all documentation that I can find ArcPro should refresh the data in a map after running a custom geoprocessing tool. This has not been my experience so far. I have tried to make this tool several different ways. The edit completes successfully, but does not show in the map unless I refresh the map view in the versioning tools. Some think that the automatic refresh will be triggered if the tool has a derived output. Others have said that it will be triggered after the arcpy.da.Editor operation is closed as long as we are working in the "CURRENT" but not sure what that means in determining a workspace. The example below incorporated all of the documented recommendations without success. All we want is a simple tool that updates a select number of attributes on an existing layer and saves them inside of the current version (shown in the map without additional action by user). Any recommendations appreciated. Built with ArcPro 2.6.2 using the New Script wizard with a single input param and a single derived output param: # Import system modules import arcpy # Set the parameters InputIDF = arcpy.GetParameterAsText(0) #Process: Start Edit prev_workspace = arcpy.env.workspace arcpy.env.workspace = arcpy.Describe('GPS').Path edit = arcpy.da.Editor(arcpy.env.workspace) edit.startEditing(False,True) edit.startOperation() arcpy.SelectLayerByAttribute_management('GPS', 'CLEAR_SELECTION') with arcpy.da.UpdateCursor('GPS',['IDFEATURE','QAPNTUSE'],'IDFEATURE={}'.format(InputIDF)) as cursor: for row in cursor: row[0] = None row[1] = 5 cursor.updateRow(row) del cursor # Cleanup edit.stopOperation() edit.stopEditing(True) arcpy.ClearWorkspaceCache_management() arcpy.env.workspace = prev_workspace # Set layer as output param p = arcpy.mp.ArcGISProject("CURRENT") m = p.listMaps()[0] l = m.listLayers('GPS')[0] arcpy.SetParameter(1, l)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

GregNicholsICF · Answer

Thanks for the workaround solution.   This seems to work this way also.

oidfieldname = arcpy.Describe(thelayer).OIDFieldName
wc = oidfieldname + ' < -1'
arcpy.management.SelectLayerByAttribute(thelayer,'NEW_SELECTION',wc)
arcpy.CalculateField_management(thelayer,oidfieldname,12345,'PYTHON3')

JeffLegato1 · Answer

I have a published GP tool that utilizes dynamic data and I can confirm that adding a calculate field pre-step to my published model seems to work. The obvious drawback is that it edits all the records so last_edited_date and last_edited_user fields are modified as well. Also, as the featureclass gets bigger it will take longer.

adminCentlec · Answer

Hi, does this workaround work in cases of published gp tools? I have published quite a few of these but I am stuck here too as the output does not automatically refresh, it needs the user to refresh the web application in order for the changes to be posted. I am going to try this and perhaps post a similar question to ESRI as to why their RefreshTOC/RefreshActiveView and others do not work at all.