Survey123 Pulldata SQL Where clause not working with special characters

RobynSnookCCB — Mon, 09 Sep 2024 13:28:20 GMT

I'm attempting to use the pulldata function in survey123 connect to get road information, I need to get the street name and use that in a future sql clause. I'm having the issue that street names with an apostrophe break the sql clause, it works fine with street names without any special characters.

This the statement:

pulldata("@layer","getValue","attributes.Total",${RoadQu}, concat("DISPLAYNAM='", ${RdName},"'"))

I've also tried this to no avail.

pulldata("@layer","getValue","attributes.Total",${RoadQu}, concat('DISPLAYNAM="', ${RdName},'"'))

thanks

Re: Survey123 Pulldata SQL Where clause not working with special characters

CourtneyZ — Mon, 14 Jul 2025 12:38:13 GMT

@RobynSnookCCB were you able to figure this out? I'm having the same issue

topic Re: Survey123 Pulldata SQL Where clause not working with special characters in ArcGIS Survey123 Questions

Survey123 Pulldata SQL Where clause not working with special characters

Re: Survey123 Pulldata SQL Where clause not working with special characters