Bob Swift SQL plugin dynamic content

[Stephen]

Hi,

I'm trying to upgrade Confluence from 3.5.11 to version 5. I have content written with old versions of plugins like Bob Swift SQL and Bob Swift Run-now. I'm about to pay for the upgrade of these two plugins as they are not free anymore since v4 of Confluence.

However before upgrading I would like to know if I can still use my pieces of code in version 5. Please look at the piece of code below:

{sql:dataSource=slfDS|output=wiki|table=false}
select
concat('[Add installation|https://companyurl/display/OPE/insert+solife+installation?run_selection=run&run_selection_clientid=',client_id,'] ',
'[Manage installations|https://companyurl/display/OPE/Manage+installations?run_selection=run&run_selection_id=',client_id,']') as link
from client where CLIENT_COD_EXT='$page_title'
{sql}

Two links are created in the SQL command, the "add installation" and "manage installation" links are created using the old wiki syntax using brakets. How could I reproduce that with the new version of the plugin and with Confluence in version 5 which is using xhtml tags now...

Many thanks for your help, hope there is a solution.

Regards,

Steven

[Bob Swift OSS (Bob Swift Atlassian Apps)]

See SQL-381.