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.
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 Community! Kesha (kay-sha) from the Confluence marketing team here! Can you share stories with us on how your non-technical (think Marketing, Sales, HR, legal, etc.) teams are using Confluen...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG