How can I use current page title in a sql query?

[Niharika Shrivastava]

I am a begginer and using Bob swift SQL plugin. My query is

SELECT * FROM OS_PROPERTYENTRY o
join CONTENT c on c.CONTENTID = o.entity_id
WHERE o.entity_key like 'vote.%'
and c.TITLE = $PageTitle

What should I use in place of $PageTitle to pass the current page title as attribute.

[Mirko Skramusky]

Hi!

I think this is the right documentation page for you: https://bobswift.atlassian.net/wiki/display/SQL/How+to+use+Confluence+metadata+in+SQL+queries. You can insert the page title via the Run Self-Service Reports for Confluence Plugin.

[Niharika Shrivastava]

Hi Mirko! thanks for your response.

Is it in anyway possible without this plugin (?), I am already using Bob SQL plugin, does that mean for such requirement, I need one more plugin?

[Mirko Skramusky]

No sorry, I don't know any other way to do this. :(