Token Not Working when Adding JSON Values

[g038123]

Hello,

Hoping for some help, I have a simple Dashboard that allows a user to select  specific geography to return results for that geo. The search is based off of a SQL query and uses tokens to determine the correct geography.

The report has been working perfectly for a long time, recently we had an upgrade to our application that added JSON columns to our DB and moved some of the fields I was returning into the JSON clob data field.

I updated the query to extract the necessary JSON fields, which works, however, now after adding the JSON details to the query, the token is no longer working. I keep getting "Search is Waiting for Input".

I have tried to move the connection argument, before and after the SQL query, see below, neither seemed to

work.

| dbxquery query="blah blah" connection=geography

| dbxquery connection=geography query="blah blah"

Hoping someone can point out what I need to add or update, so that the token is recognized/working again.

Thank you in advance for any assistance.

[renjith_nair · Accepted solution]

Would it be possible to share some sample data and part of your dashboard xml ?

It could be due to various issues including presence of a $ sign in your data which needs to be escaped while using in token.

[g038123]

Hi Sorry for the delay in responding. You have helped me immensely.

That indeed was the issues. Thank you so much for the help!

[renjith_nair]

@g038123, glad it worked.

Appreciate if you could upvote ( 👍 ) and accept it as a solution to close the thread.