sql macro in user macro to produce viewpdf macro

Description

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,

Environment

None

Status

Assignee

Sunita Patro [Bob Swift Atlassian Apps]

Reporter

Christophe Bonvin

Labels

None

Support Entitlement

None

Components

Priority

Minor
Configure