topic Re: Issue with a url query in SQL Calc Field in ArcGIS Online Questions

Issue with a url query in SQL Calc Field

RyanClose — Fri, 13 Sep 2019 18:41:30 GMT

Does anyone else have an issue in AGOL calculating a filed to update a url link with a "?" in it? Every time I tried paste a url with a query

(ex: https://<front of url>..../DistrictBallotView.aspx?DistrictKey=31...<end of url>....)

it changes the "?" to a ":"

(ex: https://<front of url>..../DistrictBallotView.aspx:DistrictKey=31...<end of url>....)

To be clear, I'd paste the url and it looks fine. I hit calculate and the result has the colon instead of the question mark.

This ONLY seems to happen in the SQL version of editing. I had to change settings on the feature class to be able to make the edit in Arcade and then change the setting back.

Re: Issue with a url query in SQL Calc Field

LanceCole — Tue, 08 Oct 2024 12:53:51 GMT

Ryan‌,

A "?" is a placeholder in a SQL statement depending where it is located in the statement. If your URL is contained in quotes as part of the WHERE clause is this should be ok other wise the SQL will replace the ? with a value. Depending upon the driver and SQL version, using a double question mark "??" or wrapping the question mark in brackets "[?]" in the URL may escape the issue. Can you provide a copy of the full SQL statement?

Re: Issue with a url query in SQL Calc Field

RobertoRossi — Tue, 08 Oct 2024 12:37:40 GMT

I have the same Issue.

Both the solutions proposed by @LanceCole do not work:

with double question mark "??" you obtain "@"
with the question mark in brackets "[?]" you obtain "[:]"

here a workaround if the value is needed for a popup: https://community.esri.com/t5/arcgis-online-questions/calculated-url-converts-question-mark-to-colon/td-p/1288161

Roberto