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

Question

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!

Naomi Williams · Answer

@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!

Matthias Gaiser _K15t_ · Answer

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=page and Space=TEST and created > startOfYear()

Hope that helps,
Matthias

Russell Zera · Answer

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.