It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to get modified content within a date range instead of lastModified ?

I want to get content (could be a version older than the latest) from a cql search with a given date range.

For eg: currently what is listed in the doc is doing a search like this :

http://localhost:8090/rest/api/content/search?cql=( lastmodified > "2020/04/13 14:05" and lastModified < "2020/04/13 14:13")

But the problem with this query is that if there is an id, say 123456 with version 4 and version3.

The content 123456 has version 4 on 2020/04/13 14:20 (which is more recent than the date specified in the query above)

Content 123456 has version 3 within the date range specified as above in the query.

The above query does not return any results since the lastModified does not fall within this range.

How can I get version 3 with a query similar to above or if there is an alternative approach ?


1 answer

1 accepted

0 votes
Answer accepted

@sabzx, to my knowledge, you cannot search through Confluence page history the way you described. Even though it does not explicitly mention CQL, you'll find a similar question answered by Shannon here.

There are other questions that sort of touch on the same topic but slightly different. These are a few examples. Have a look at them.


Thanks Ivan !

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Confluence

Lessons and Learnings: Six Months of Working Remote [Discussion]

Hey there, folks! For most of us, the past six months- yes, you read that right- have been a journey. More people than ever before have pivoted to working remotely, and navigating being on-scre...

4,120 views 4 6
Join discussion

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