How to make a dynamic select with url parameter in a Run Self-Service Reports - Run Macro?
I have a “Run with a user form and parameters” macro where I want to have a dynamic select that uses a url-inputparameter in like this:
"select name from areas where id = cast($departmentNumber as varchar(3))"
I am calling the page lik this: …/Test+Dynamic+select?run_1_departmentNumber=201.
When I do, I got this error message: “Please verify if you have installed/enabled SQL for Confluence, and that your query is valid.”
If I change my sql-query to “select name from areas where id = 201” then there is no error message and I got expected behavior.
What should be changed to get it working using a url-pram. ?
From source-editor:
<ac:structured-macro ac:macro-id="fd7579ef-ec79-4886-b5ff-9b1e108c8cd7" ac:name="run" ac:schema-version="1">
<ac:parameter ac:name="replace">departmentNumber::departmentNumber:dynamic-select::SAM:select%20name%20from%20areas%20where%20id%20%3D%20cast(%24departmentNumber%20as%20varchar(5))%0A</ac:parameter>
<ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
ac:rich-text-bodySelected value: $departmentNumber</ac:rich-text-body>
</ac:structured-macro>
