Service Line Self-Assessment Dashboard - Arcade error in Current Submissions List element

498
2
Jump to solution
02-22-2023 10:51 AM
JayHodny
Occasional Contributor III

Hi. I am working with the Service Line Self-Assessment Dashboard and am getting an Arcade error in the Current Submissions List element.  I have two test records collected using the Survey123 app from the solution.  When I first opened the Dashboard, the List element would not show any records, while the spin icon simply spun.  I went into the configuration panel and reselected the Service Line Self-Assessment_viewing layer.  The two records then appeared in the List, but both had these error messages (below).  In the Survey123 web application, there is an ObjectID for each record (1 and 2).  In the List configuration panel there is some Arcade script in the Advanced Formatting tab, but I have no clue what to do here, if anything.  Any help would be greatly appreciated. Regards, Jay

Unable to execute Arcade script for Feature Objectid 1
Unable to execute Arcade script for Feature Objectid 2

JayHodny_0-1677091431121.png

 

0 Kudos
1 Solution

Accepted Solutions
AlexKabak
Esri Contributor

Hi Jay,

This is an arcade issue which we patched back in early January. ArcGIS Online and ArcGIS Enterprise use different casing, and in some instances different names, for system generated fields like ObjectID, GlobalID, and editor tracking fields. Since Lead Service Line Inventory deploys to both, we set parameters to use the correct casing dependent on which portal it is deployed to.

At the initial release of Lead Service Line Inventory v3.0 back in November, the parameter was set incorrectly. As a result, the editor tracking fields in the Arcade in the Dashboard referenced above was hardcoded to the Enterprise casing (lowercase) which is different from the Online casing (mixed case).

To fix this follow the steps below:

  1. Open the Service Line Self-Assessment Dashboard in edit mode in order to configure the dashboard.
  2. Hover over the Current Submissions list and click the Configure button
  3. Click the List tab in the left pane
  4. In the Advanced formatting window, on line 9 update $datapoint.created_date to $datapoint.CreationDate
  5. Repeat for the Completed Submissions list

View solution in original post

2 Replies
AlexKabak
Esri Contributor

Hi Jay,

This is an arcade issue which we patched back in early January. ArcGIS Online and ArcGIS Enterprise use different casing, and in some instances different names, for system generated fields like ObjectID, GlobalID, and editor tracking fields. Since Lead Service Line Inventory deploys to both, we set parameters to use the correct casing dependent on which portal it is deployed to.

At the initial release of Lead Service Line Inventory v3.0 back in November, the parameter was set incorrectly. As a result, the editor tracking fields in the Arcade in the Dashboard referenced above was hardcoded to the Enterprise casing (lowercase) which is different from the Online casing (mixed case).

To fix this follow the steps below:

  1. Open the Service Line Self-Assessment Dashboard in edit mode in order to configure the dashboard.
  2. Hover over the Current Submissions list and click the Configure button
  3. Click the List tab in the left pane
  4. In the Advanced formatting window, on line 9 update $datapoint.created_date to $datapoint.CreationDate
  5. Repeat for the Completed Submissions list
JayHodny
Occasional Contributor III

Hi Alex,

The steps outlined above worked.  Thank you.

Sincerely, Jay

0 Kudos