Using site title as Variable in confluence

[André Stefaniak]

Hello,

i want to make a SQL query(with SQL Pro plugin) which depends on the site Title.

something like this:

select hostname, dbname from hosts where hostname like SiteTitle;

Is that possible?

Thanks in advance.

[rsperafico]

Hello @André Stefaniak,

You could be doing the following:

• Install Bob Swift add-ons
  https://marketplace.atlassian.com/plugins/org.swift.confluence.run/server/overview
  https://marketplace.atlassian.com/plugins/org.swift.confluence.sql/server/overview
• Set up Confluence's DataSource (Configuring a datasource connection
• Go to the desired page and hit Edit
• Hit the + sign and select Markup, adding the following:
  

  {run:autorun=true|hideParameters=true|hideRun=true|replace=first:$page_title}
  {sql:datasource=ConfluenceDS}
  select hostname, dbname from hosts where hostname like '$first'
  {sql}
  {run}

  Where 'ConfluenceDS' is the name given to the DataSource configuration.

Kind regards,

Rafael