laptop and a wrench

Bogue

Using Arcade expression in the Expression Builder in ArcGIS Pro's Attribute Rules to update a feature that contains an apostrophe throws an error: "Invalid where clause (Field Name = 'data's')".

ArcGIS Pro
Numéro d’ID de bogue BUG-000176096
EnvoiApril 28, 2025
Dernière modificationJune 19, 2025
S’applique àArcGIS Pro
Version trouvée3.3
Système d’exploitationWindows OS
Version du système d’exploitationN/A
StatutAs Designed

Informations supplémentaires

Crafting the SQL string manually is error prune, Use template literals when applying where clauses, Refer to this blog: https://community.esri.com/t5/attribute-rules-blog/attribute-rule-authoring-and-configuration-tips/ba-p/1023745 for more information. For example: var fsTable = FeatureSetByName($datastore, "table") var objectIds = [1,2,3,4,5] var whereClause = "objectId in @objectIds"; fsFilter = Filter(fsTable, whereClause);

Solution de contournement

Crafting the SQL string manually is error prune, Use template literals when applying where clauses, Refer to this blog: https://community.esri.com/t5/attribute-rules-blog/attribute-rule-authoring-and-configuration-tips/ba-p/1023745 for more information.

For example:

var fsTable = FeatureSetByName($datastore, "table") 

var objectIds = [1,2,3,4,5]

var whereClause = "objectId in @objectIds";

fsFilter = Filter(fsTable, whereClause);

Étapes pour reproduire

ID de bogue: BUG-000176096

Logiciel:

  • ArcGIS Pro

Recevoir une notification lorsque le statut d’un bogue change

Télécharger l’application Esri Support

En savoir plus sur ce sujet

Obtenir de l’aide auprès des experts ArcGIS

Contacter le support technique

Télécharger l’application Esri Support

Accéder aux options de téléchargement