Select to view content in your preferred language

pulldata @layer returning no results

324
2
08-27-2023 06:55 AM
susic
by
New Contributor

I am attempting to pull data from a simple layer.  the Layer has 2 fields, "event_name", and "active".   I am trying to query the layer in the calculation field for a text question in Survey123 Connect 3.18 to return the event name that has the active field set as yes.  The layer is set to public.  

The question never pulls any data.  If the quotes are removed from around the yes, I recieved a message in the text box that yes is not defined.

pulldata("@layer", "getValue", "attributes.event_name", "https://services1.arcgis.com/YBWrN5qiESVpqi92/arcgis/rest/services/service_400a7c2583ae4a558c1c675e6...", active = "yes")

Any guidance would be appreciative.

 

0 Kudos
2 Replies
JodyZhengLiu
Esri Contributor

Hi @susic ,

The "active = 'yes'" should be quoted as well:

pulldata("@layer", "getValue", "attributes.event_name", "https://services1.arcgis.com/YBWrN5qiESVpqi92/arcgis/rest/services/service_400a7c2583ae4a558c1c675e6...", "active = 'yes'")

Thanks,

Jody Zheng Liu

susic
by
New Contributor
0 Kudos