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

Question

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 [Communardo] · Answer

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

Niharika Shriva · Answer

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 [Communardo] · Answer

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.