Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,300,883
Community Members
 
Community Events
165
Community Groups

Confluence Advanced Search: How to find only pages created after a certain date

Russell Zera Community Leader Nov 09, 2021

Hey, I know I have come across numerous old solutions to this in Confluence Server, but I am struggling to find this in Confluence Cloud. I am looking for find and capture data to show the total number of pages created within a given timeframe (data like a chart showing rate of content creation could potentially be valuable). I am unable to find what I am looking for, best I can get is "Last modified" and it does not give me the option to add additional filters. Any tips/tricks/suggestions? This might be ultra simple and I'm just having one of those days where it's right in front of me.


Scenario: 
I am looking to find a listing of all pages created in 2021 within a single space in our instance, and furthermore, only pages created under a specific top-level page. BONUS: to be able to FLIP that search result to show only pages created BEFORE 2021 (meaning I can add them both together as a consistency check to ensure the two results add up to the total number of pages within the top-level page).

Thanks in advance!

2 answers

0 votes

Hi @Russell Zera ,

would you be fine in using the REST API for that? Using the Confluence Cloud REST API, you can search using CQL which allows you to define a query filtering on the created property.

So, a possible CQL might look like this:

type=page and Space=TEST and created > startOfYear()

and the corresponding url:

https://your-domain.atlassian.net/wiki/rest/api/content/search?cql=type%3Dpage%20and%20Space%3DTEST%20and%20created%20%3E%20startOfYear%28%29

Hope that helps,
Matthias

0 votes
Fabian Lim Community Leader Nov 09, 2021

Hi @Russell Zera

There is one option via the advanced search.

Steps:

- Open the search

- Go to "advanced search" at the bottom

- Add the bottom click on Add Filter, where you can select certain filelds such as "created"

- Select Custom

- Add a range

- You will see this:

date_filter.png

Russell Zera Community Leader Nov 09, 2021

Thanks @Fabian Lim ! That is what I had found in online documentation as well, only problem is that I am not seeing the ability in Advanced Search to Add Filter. This is all I see... I'll be THRILLED if I'm doing it completely wrong and you point out my miss... but I'm not seeing it. 2021-11-09_14-37-27.png

Like # people like this

@Russell Zera did you ever get the information on how to 'add' an additional filter?  I need to add 'created' and cannot add it.  any help if much appreciated.  thanks!

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

An update on Confluence Cloud customer feedback – June 2022

Hi everyone, We’re always looking at how to improve Confluence and customer feedback plays an important role in making sure we're investing in the areas that will bring the most value to the most c...

388 views 2 13
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