This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have similar issue when data has colon character, the drop down does not handle that elegantly and instead truncates the string after the colon character. The value comes from the database and I have tried escaping using a backslash, double quote, single quote but in vain. Firebug in Firefox browser when in debug mode shows that the data is handled as a JSON object, but there is nothing beyond that to indicate what might be the problem. Can anyone suggest, how to circumvent this situation?
So this is going to sound like a cheap answer, but I don't think I ever solved this issue.
My recommendation, if you can do it, would be to do a REPLACE, rather than trying to escape the colon. Try using a semi-colon, or some other character? I'm not sure if the colon is a requirement in order for the value to work properly for you.
If for some reason the colon is a requirement, I would recommend reaching out to Alteryx Support directly to see if they can help you with that. Since you were trying to escape the character previously, I'm guessing you can change this value?
Thank you for your contributions to the Community. I wanted to let you know that we are aware of this issue and it is currently in our defect backlog for resolution in a future release. Unfortunately, we do not have an ETA at this point. @Claje is absolutely correct that the colon is the culprit in the Gallery version of the app, and not just when dealing when DateTime values. A colon in any part of the string of the Name field will truncate the text after the colon. So the workaround is to replace any colons in the Name field with another character.
Thank you and we are sorry for any inconvenience.
Dan Chapman Program Manager, Customer Support New to the community? Get started here.