In my query I want to request some data from a mysql-database.
The Query is something like the following:
select field1, field2
where field3 = :name
The actual query is more complex but that won't change anything for this example.
My Problem is that the name I am search for consits of characters like &,...
When I add the macro (with active debug) to the page and use 'test1 & test2' as Value for name, the debug information shows that the vaule is cut at the special char.
Query parameters: [name=test ]
Query execution time: 49 ms
Template parameters: 
How to handle this?
Bad news: unfortunately I had to roll-back this solution because it caused serious issues in different cases. I'm still searching for a solution for the issue and I'll try to integrate it in our release 2.1 which will be released soon. I would recommend to switch back to the marketplace version and live with the "&" issue for some more time, since the version I gave you might cause issues as soon as you update PocketQuery to the next official version.
I'm really sorry for the inconvenience and I promise I will find a solution for this!
Regards, Felix (Scandio)
What is not working is ... WHERE Field1 IN (:Filter) ... being the "Filter" a ListOfStrings in which one of the items is 'Backup & Restore'...
I found a work around using the replace function in SQL to replace the '&' by the '-' and then it works!!! but what is stored in the (Oracle) database is the 'Backup & Resore'...
Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time! We're looking for people to participate in a remote 1-hr workshop...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs