I am wondering that is there be any macro OR any workaround which could help me regaring the label attachment to pages.
e.g. I have 3 pages and i have added labels to each of them on different dates Therefore, I want to know when Labels are attached (date).
Thanks in advance
With best regards,
I've created this SQL query for you:
select l.name as LabelName, c.title as PageName, cl.lastmoddate, cl.owner from content_label cl join label l on cl.labelid=l.labelid join content c on cl.contentid=c.contentid where c.title like "<page name>" and l.name like "<label name>";
This query will show you the label name, page title, when the label was added, and who added. You'll need to change the <page name> and <label name> for the actual page name and label name you want to verify. :)
I hope this helps!
Thanks a lot for your answer! (I work with Usman :)) I'm trying to use the SQL macro with your query.
But I have a problem with the datasource. I know that the database name is "confluence". But it doesn't work.
Could you please tell me how should I fill in the datasource field?
Thanks again and kind regards
This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.Read more
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
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs