Latest Contributions by danbecker

We have several repeats in a form that hold images. To force those repeats to start a new page in the template, we added a Word Section Break (Next Page) inside of a S123 conditional statement, like so.   Then the "general_photos" section starts, printing exactly 2 photos on each page. Works great. But, after the last "general_photo", if there are NOT any "cultural_res_photos" (see condition after the photo table above) we still get a blank page inserted at the end, because of the Section Break (Next Page).  How do we control this? Even though that condition is NOT met, the Section Break still gets inserted.  All I hear about, is how AI is coming for my job, yet, in our Azure GOV environment, there is NOT a way to have a powerautomate flow or AI, delete the last page of the generated feature report, LOL.    ... View more

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