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.
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.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
No sorry, I don't know any other way to do this. :(
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.