I have one macro which is calling a sql macro producing a list of email addresses. In another macro I want to call this and have the value placed into a field, not shown on a screen.
Behind this is the sql query add on for Confluence.
Attempting to do something along this lines of:
#set ($emaillist = $action.getHelper().renderConfluenceMacro("{mymacroname:PARM1=$paramP1}"))
The value of emaillist is always blank, the macro runs but shows the information on the page.
Any suggestions?