Hello,
I want to have a user macro which will run a sql query based on the name of the page. The result of the query ist a {viewpdf} macro. Using the user macro on a page will make it render a view pdf of a file attached somewhere.
If I put a sql macro on my page, for exemple :
{sql-query:datasource=tribuna|heading=0|output=wiki}
select '{viewpdfage=Model|name=file.pdf}' from dual
{sql-query}
the result is displayed correctly,
If I put this code into a usermacro:
#set ($runMacro =" {sql-query:datasource=tribuna|heading=0|output=wiki|table=false}
select '{viewpdfage=Modèles_TCV_pdf|name=$AJRECUP.pdf}' from dual
{sql-query}")
$action.getHelper().renderConfluenceMacro($runMacro)
The viewpdf file do not display the pdf.
(in my real case, I use in the user macro the name of the page to retrieve the data source and some other parameter).
Any ideas how to solve this ?
Thank you,