It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Is it possible to know the dates when labels were attached to pages in Confluence.

Mani1 Jul 21, 2013

Hi,

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,

Usman Akram

1 answer

0 votes
Rodrigo Adami Atlassian Team Jul 22, 2013

Hi Usman,

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!

Regards,

Rodrigo

Marta San Martin Jul 24, 2013

Hi Rodrigo!

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

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Confluence

Confluence CVEs and common questions

Two vulnerabilities have been published for Confluence Server and Data Center recently: March 20, 2019 CVE-2019-3395 / CVE-2019-3396 April 17, 2019 CVE-2019-3398 The goal of this article is...

860 views 0 19
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you