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

[Mani1]

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

[Rodrigo Girardi Adami]

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]

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