I have a pocket query that I have set up as follows:
from table(devpromo.PROMO_CONFIGURATION(:promo_code, :promo_sequence, :environment)) a
The following Parameters are being submitted via the form.
Param1: FIOS BB & FIOS
This is what the debug shows as what was submitted.
Query parameters: [environment=CPLMS promo_code=FIOS BB promo_sequence=13 ]
User: Miller, Tim
Page: Promotion Trouble Shooting Inquiries
Query execution time: 2094 ms
Template parameters: 
For some reason it is dropping everything from the & on in the Param1.
I've searched through google and atlassian answers and can not find anything except on your blog it mentions the following:
We have version 2.1.2 installed.
Any ideas on how I make it so the & is passed through in the string and doesn't cause it to stop at the & in the string?
Thanks for any help!
This has actually been an issue before PQ 2.1. It originated in this post: https://answers.atlassian.com/questions/38382530. But this issue was actually fixed with 2.1 and I cannot reproduce that issue any more. What I tried...
I have a table with countries and one country name is "Trinidad & Tobago". I wrote this query:
SELECT Name, Population FROM Country WHERE Name = :Name
In the macro I enter "Trinidad & Tobago" for the parameter "Name". The result is the correct one with the "Trinidad & Tobago" row.
Then, I added your query in the PocketQuery admin:
select * from table(devpromo.PROMO_CONFIGURATION(:promo_code, :promo_sequence, :environment))
I entered the parameter values as you suggested, but I don't get the behaviour with the cut-off value for promo_code:
Are you really sure you are running on PocketQuery 2.1.x?
Best, Felix (Scandio)
It started as any story starts, on a normal, rainy day. Admin meets App, and her name was Klok2, and like any first relationship we were both trying to make it work but neither one knew what...
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