Analysis Widget not showing updated data

[RachelS]

Hi,

I created a Custom Web Tool using the Analysis widget to run a report on a chosen objectid of a record.

So a user submits the data through Survey123, then a different user updates a few fields in the table of Experience Builder of the record that has been submitted. Then they use the Analysis Widget to run a report showing all the fields of the record.

The problem is the report only shows the details of what the original user has submitted. It leaves the updated fields blank. I tried turning on auto refresh on the layer in Experience Builder and in webmap, I've refreshed the mapviewer, cleared the cache but it makes no difference. It doesn't recognise the new data added even though the fields are in the report.

Has anyone come across this?

Thanks

Rachel

[Wei_Ying]

Hi @RachelS ,
Does the data update to the layer exactly and shows good in other widget and Map view?  But not working in Analysis
Can you share your custom tool if possible? 

[RachelS]

Hi @Wei_Ying 
I opened a case with ESRI and turns out this is expected behaviour.
That in a published GP service, the report executes in a server side ArcGIS Pro instance. The report does not re query the feature service for updated attributes or refresh values. The .aprx and report are therefore loaded using the attribute values as they were originally resolved.

When the GP tool runs, the report can detect that a new feature exists (report.definitionQuery = f"OBJECTID = {objectid}") and include a row for it, but it does not re read the feature’s attribute values from the source layer. As a result, fields edited after submission remain blank in the report, so edits made in Experience Builder are not reflected in the exported PDF.

The solution was to build a custom Enterprise print service with report templates, used via the Print widget.