Search pages by "published date" or "date created" or "created by"

Denis Nosov_z1jfz8

Hi, community!

I need to find all pages created after some date e.d. January 1 2022.

I've tried to search thru Search field with queries like 'created >= "2022-01-01"' or 'created by = "John Doe"' etc. with no success.

Also I've searched thru Advanced search, but with no success too - there are no proper filters and no button "Add filter".

Marta Woźniak-Semeniuk_m044pw

Hey @Denis Nosov 

There was a discussion here about filters for pages based on dates https://community.atlassian.com/t5/Confluence-questions/How-to-show-all-confluence-pages-created-in-the-last-week/qaq-p/709879 

 

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).