How to show all confluence pages created in the last week?

[paul enggruber]

Seems very easy question, but i want to Show all pages that are created in the last week, without showing pages that were created earlier but are edited in the last week.

Thanks for ýour help!

paul

[Stephen Deutsch · Accepted solution]

Hi Paul,

If it's a big international company, then it's likely that they are running Confluence on their own servers, as normally the Cloud version only has a maximum of 2000 users.

There's another way to set up a search result of pages created in the last week, but you need to have the Confluence Source Editor installed (so this would only work for Confluence Server, although you could probably get it to work for Confluence Cloud by changing the source through the API).

Insert the "Content By Label" macro into the page, choose any random label, then add a filter for type and choose "Page", add a filter for created and choose "Last Week", expand the options and choose sort by "creation", check the box "Reverse Sort", set maximum results as 99999, and uncheck the box "Show Labels for Each Page", then save the macro.

Since you have the Source Editor installed, click the "< >" icon in the upper right (note that it only appears after the page has been saved at least once), find the macro "contentbylabel" and under the cql parameter remove from the beginning "label = <randomlabel> and " and then click "Apply".

Once you save the page then you should have a list of pages created in the last week sorted by creation date (most recent at the top).

[Thomas Schlegel]

Hey @Stephen Deutsch, I didn't know this hack! Awesome!! :-)

[paul enggruber]

Thats Awesome! This gives me the chance to get almost every filter I want!

If I have such a filter, is there a way to also show it in JIRA, if I do not have the right to subscribe to Confluence Gadgets?

Thanks a lot!

Paul

[Stephen Deutsch]

Thanks @Thomas Schlegel and @paul enggruber!

As far as whether there is a way to show this in Jira, unfortunately I'm not totally sure, especially if you don't have the right to subscribe to Confluence Gadgets.

[James Tuttle]

Brilliant answer, thanks!

[Thomas Schlegel]

Hi Paul,

you can search for that in the search window of Confluence:

http://<your-confluence-url>/dosearchsite.action?cql=created+%3E%3D+now(%27-1w%27)

Or manually:

1. click on "Add a filter"
2. Choose "Created" and then "Last Week"

[paul enggruber]

Hello Thomas,

Thanks for your quick Reply. I would like to show These pages on top of my Dashboard, so I guess I have to integrate the "search" makro and find the right "search text". I am not sure how to apply your method for this.

Best

Paul 

[Thomas Schlegel]

Hmm, this is tricky. I would use the app "Reporting for Confluence" for creating such a result page. There may also be other apps, but this is the one, we use for reporting content from Confluence. The framework is not so easy to understand, but it is very powerful. 

I don't know another way to put a search result on a page. Maybe a link to the search itself might be sufficient for you?

[paul enggruber]

Hello Thomas,

I inserted the link know, and hope it will be sufficient!

The Reporting for COnfluence app does not seem to be available in the Confluence I am working. i dont have rights to add it.

Thank you very much!

[Thomas Schlegel]

You're welcome, @paul enggruber

Do you use the cloud version of Confluence? This Reporting app is only available for the server-version.

[paul enggruber]

I guess it is the Cloud Version, since it is for a big international company