topic Re: Token Not Working when Adding JSON Values in Dashboards & Visualizations

Token Not Working when Adding JSON Values

g038123 — Fri, 07 Aug 2020 22:46:50 GMT

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.

Re: Token Not Working when Adding JSON Values

renjith_nair — Sat, 08 Aug 2020 05:48:05 GMT

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.

Re: Token Not Working when Adding JSON Values

g038123 — Tue, 11 Aug 2020 15:59:48 GMT

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

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

Re: Token Not Working when Adding JSON Values

renjith_nair — Fri, 14 Aug 2020 08:46:59 GMT

@g038123, glad it worked.

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