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

Niharika Shrivastava July 8, 2014

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.

1 answer

0 votes
Mirko Skramusky
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 8, 2014

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 July 9, 2014

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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 9, 2014

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events