Select to view content in your preferred language

pulldata("@layer", "getValue", does not work when I use a text field

63
1
Tuesday
SanchezNuñez
Frequent Contributor

Good morning,

I am trying to query data from a hosted feature table with pulldata. When I use a numeric field as the key, it retrieves the data correctly, but when I use a text field, the query does not return anything.

pulldata("@layer", "getValue", "attributes.Description", "https://services.arcgis.com/..../FeatureServer/4", concat("OBJECTID=", ${ID}))

pulldata("@layer", "getValue", "attributes.Description", "https://services.arcgis.com/..../FeatureServer/4", concat("Activity_Type='", ${Activity}), "'")

 

 

0 Kudos
1 Reply
Neal-Kittelson
Frequent Contributor

Try pulling your concat function out of the calculation into a helper field, and then reference that field in the pulldata calc.

ActivityTypeCon = concat("Activity_Type=", ${Activity})

pulldata("@layer", "getValue", "attributes.Description", "https://services.arcgis.com/..../FeatureServer/4", ${ActivityTypeCon})

0 Kudos