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')".

附加信息

解决办法

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);

重现步骤