CQL: Order by created

Question

Hi , hope all in good time.

We are trying to sort this CQL by the created parameter as per below CQL.

type=page and created >= startOfMonth("-90d")

Referred to the docs, but got the error when compiling

Could not parse cql

CQL that has been tried

type=page AND created >= startOfMonth("-90d") AND order by created

type=page AND created >= startOfMonth("-90d") asc

type=page order by created AND created >= startOfMonth("-90d")

(type=page order by created) AND (created >= startOfMonth("-90d")).

Any pointers we missed or we should look at?

Appreciate your response in advance!

Kamal Iqlaas Ismail · Answer

Yes, I got that working too, but when you add the order by filter, for me the CQL did not work.

Yes, familiar with the Postman tool!

Appreciate the response @Lee Wonnacott !

Have a nice weekend!

Lee Wonnacott · Answer

I was able to get the CQL query working by making a REST call to the following:

<base_url>/rest/api/content/search?cql=type=page+and+created+>=+startOfMonth("-90d")

It might be worth trying the same query within a tool like Postman to check it's working as expected before testing it within your app!

I hope you're able to get everything up and running! :D

Kamal Iqlaas Ismail · Answer

@Lee Wonnacott , just confirmed with my colleague

We are making a call to the Confluence Rest API.

Hope this helps!