Symbolising using Arcade for values not in the Feature Layer

Question

Hi Community. I am trying to symbolise a layer using the following Arcade Expression:

var operationalStatus = $feature.OPERATIONALSTATUS;
var ownership = $feature.OWNERSHIP;
return When(
operationalStatus == "In Service", 1,
ownership == "PPP", 2,
operationalStatus == "OOS Abandoned", 3,
operationalStatus == "OOS Demolished", 4,
operationalStatus == "OOS Maintained", 5,
operationalStatus == "Planned", 6,
operationalStatus == "Disposed", 7,
999
);

I am symbolising on the number returned from this statement. Currently in my data I don't have and values for operationalStatus ==  "Planned" so the number 6 is absent from the returned symbology list, however I would like to assign a symbol for it as it may occur in my data in the future.

Without adding a dummy record that meets the criteria of operationalStatus == "Planned" to my data is there a way of being able to symbolise for all these values? This is just an example of a larger symbolising exercise I am undertaking across features so adding the records to the data isn't the feasible solution at this point.

CyrilDynkaMrvaPVK · Answer

Hello, I suggest opening a support ticket and linking it to the existing BUG-000161636: "Add unlisted value options triggers an error message 'Requested operation could not be completed' while adding a new value, under the symbol class using custom arcade expression."

We have developed a custom Python tool using CIM access for our needs. Now we can add all symbol classes from the Arcade expression, even if they don't have any features in the data.

Unfortunately, the symbol classes with zero features in the data disappear every time you want to edit the Arcade expression in the layer manually later. Consequently, we need to use the tool every time we want to change anything in the Arcade expression and define the symbols again.

It would be great if this BUG could be resolved/fixed soon.

Robert_LeClair · Answer

Yes but.... Normally, In ArcGIS Pro > Symbology (Unique Values) you can manually add a class for a value that doesn’t currently occur in the data.

* Open the layer Symbology pane and set Primary symbology = Unique Values (with your Arcade expression in Field 1).
* On the Classes tab, click the Green Plus sign.
* Click the the Options dropdown, add new value.  And from here it throws an error - "requested operation could not be completed"...normally you'd go to Step 4 and be done...
* Click Add new value and type the value you want to symbolize (in your case, add the missing returned value, e.g. 6, and set the label to Planned).
* Assign the symbol you want for that class.

But here's what I learned...there's a BUG.  "BUG-000161636 : Add unlisted value options triggers an error message 'Requested operation could not be completed' while adding a new value, under the symbol class using custom arcade expression."

Not sure when it will be fixed as it's listed "under consideration."

AlfredBaldenweck · Answer

Huh. My workaround I was going to suggest (green plus button) is not an option for arcade symbology, apparently.

Submit an Idea for this and I'll upvote it. I may put in a support ticket, too.