Latest Contributions by danbecker

The goal is to publish a geoprocessing tool that: Opens predefined Pro project Sets definition queries on hosted feature service layers (date ranges) Turns ON the hosted feat. service layers Zooms to a predefined bookmark Exports to JPG Pretty simple, right? Not so much. No matter what we do, the hosted feature service layer(s) aren't drawing. Sometimes they do draw, sometimes they don't; most often not. Can anyone spot an issue?  import arcpy, os, time from datetime import datetime start_date = arcpy.GetParameterAsText(0) #1761486465000 end_date = arcpy.GetParameterAsText(1) #1762004877000 report_type = arcpy.GetParameterAsText(2) #"Cultural Resources" project_area = arcpy.GetParameterAsText(3) #"Project 1" output_map_filename = arcpy.GetParameterAsText(4) #"aTest" output_map_file = arcpy.GetParameterAsText(5) lyr_wildcard = "CR*" if report_type == "Cultural Resources" else "NR*" start_date_str = datetime.fromtimestamp(start_date / 1000).strftime("%m/%d/%Y") if str(start_date).isdigit() else start_date end_date_str = datetime.fromtimestamp(end_date / 1000).strftime("%m/%d/%Y") if str(end_date).isdigit() else end_date arcpy.env.overwriteOutput = True def find_dt_field(lyr_datasrc): flds_to_ignore = ["created_date","last_edited_date"] for fld in arcpy.ListFields(lyr_datasrc,"*_date","DateOnly"): if not fld.name in flds_to_ignore: return fld.name break aprx = arcpy.mp.ArcGISProject(r"\\nafiles-our.domain.com\Weekly Report Map GP Tool dev.aprx") m = aprx.listMaps("weekrep")[0] lyrs = [l for l in m.listLayers(lyr_wildcard) if not l.isGroupLayer] for lyr in lyrs: if lyr.supports("DEFINITIONQUERY"): dt_fld = find_dt_field(lyr.dataSource) sql_query = dt_fld + " >= date '" + start_date_str + "' AND " + dt_fld + " <= date '" + end_date_str + "'" lyr.definitionQuery = sql_query lyr.visible = True lyt = aprx.listLayouts("Weekly")[0] mf = lyt.listElements("MAPFRAME_ELEMENT", "LAYERS Map Frame")[0] bookmark = m.listBookmarks(project_area)[0] mf.zoomToBookmark(bookmark) time.sleep(15) #let all the complex labels draw output_file = os.path.join(arcpy.env.scratchFolder,output_map_filename) pdf_export_format = arcpy.mp.CreateExportFormat("PDF",output_file) pdf_export_format.georefInfo = False pdf_export_format.resolution = 300 pdf_export_format.imageCompressionQuality = 100 arcpy.SetParameterAsText(5, lyt.export(pdf_export_format))   ... View more

I have a nested repeat of noncompliance and noncompliance_photos. ${#noncompliance} $#{noncompliance_photos} ${/} ${/}   In a feature report template, how do I use the $feature keywork to get the position of each record?  ${#noncompliance}${if (noncompliance_photos | getValue:"count")>0} Non-compliance Number: ${$feature | getValue: "position"} Photo Number: ${$feature | getValue: "position"} ${/}${/}   The above only gets the position of the inner-most repeat, not the parent repeat.  Any help with this?  ... View more

I'm filtering a repeat in a report template like so, works great.  ${#issues | where:"issue_resolved='Yes'"} ${rpt_issue_info_resolved} ${/}   Is there a way to add a condition to that filtered repeat, that depends on the count of the filtered records? Something like this: ${if (issues | where:"issue_resolved='No'" | getValue: "count") > 0} ${#issues} ${rpt_issue_info_unresolved} ${/}${/}   I keep getting invalid expression... thanks! ... View more

Why can't I retrieve any attachments when using an attribute rule, Insert trigger on a layer that has attachments enabled?  This is an Enterprise Geodatabase that's published to Enterprise 11.4 as a referenced feature service. Both methods below fail to retrieve the attachment on the photo_point layer. Count(Attachments($feature)) //always reports 0 var sql = Concatenate(["(rel_globalid = '",$feature.globalid,"')"]); var photoTableFeatSet = Filter(FeatureSetByName($datastore,'dbname.dbo.photo_point__ATTACH',['rel_globalid','att_name'],false),sql); Count(photoTableFeatSet) //always reports 0     I even setup a feature service webhook on photo_point layer, listening for 'AttachmentsCreated', which successfully fires a powerAutomate flow.  But, inside the flow, calling /extractChanges, with the below query params { "token": "validToken", "dataFormat": "json", "layers": "[5]", "returnAttachments": "true", "returnAttachmentsDataByUrl": "true", "f": "json", "serverGens": "1742307850054,1742307850055" }   then the returned change "attachments" value always is this: "attachments": { "adds": [], "updates": [], "deleteIds": [] }   what is happening?  All I want to do is retrieve attachments on a feature that is inserted into a layer. Either by attribute rule or feature service webhook, I don't care!  ... View more

We have a fairly complex Arcade script that executes on Enterprise Geodatabase feature class Insert via a sync from an offline area in the field maps app.  If we query the feature class using Filter(FeatureSetByName()), the returned feat_set does not contain $feature that triggered the attribute rule.    var calcFeatId = -99; var sqlexpression = "feat_id = @calcFeatId" var feat_set = Filter(FeatureSetByName($datastore,'mydb.dbo.pt_layer',['globalid'],false),sqlexpression); return { 'attributes':{ //values to calculate on $feature 'feat_id': calcFeatId } };     Is this expected behavior?  Further, what if that same attribute rule modifies attribute values of $feature. Would the above query include $feature in the filtered featureSet?  ... View more