CQL Query for "Page Status"

[Ken Young]

With Automation for confluence now live, I was wondering if there is a way (via CQL) to query for "Page Status" in confluence?

[Levente Szabo _Midori_]

@Ken Young 

May I ask what automation action you want to fire based on "page status"?

[Ken Young]

Hi @Levente Szabo _Midori_ .  My goal is to have an administered status for pages  (ie. not to us tags) and to be able to automate documentation "freshness" checks.   The CQL would provide the metadata for the lifecycle of the document. Some documents can be marked "Don't review" and be ignored (via the CQL), others in different statuses could then  have notification workflows automatically kicked off, or associated Jira Tickets created to track the "updates" to the docs.

Thx

[Levente Szabo _Midori_]

In this case, I recommend looking into the dedicated Confluence lifecycle management solution, Better Content Archiving for Confluence. After becoming a go-to tool on Data Center and Server, it will be soon available for Cloud as well.

Request early access by writing a line to me at levente.szabo@midori-global.com or join our Slack.

Better Content Archiving allows you to create your own set of statuses with their CQL definitions and build your content status schemes. The app automatically classifies content based on your rules and you can launch content review workflows using notification emails.

As a next step of the launch process, automatic archiving of Confluence pages will also be available.

Read more about the Early Access Program and the app in this Community post and watch the tutorial video here!

It's free until the GA release and Early Access users are in for discounts at the official launch.

(Please note that I'm part of the team developing Better Content Archiving for Confluence.)

[Ken Young]

Thanks for the product info.

Honestly, would rather fix via automation because it is a simple use case that really doesn't need to have larger reoccurring monthly cost.  Hopefully this information is exposed to CQL in the future.

[Ashley Hudson]

Heya @Ken Young ,

I believe the CQL you are looking for is the following:

space = "xxx" AND status = XXX 

I hope this helps and let me know if you have any other questions!

Kind Regards,

Ashley Hudson

[Ken Young]

 I couldn't seem to find this in the CQL docs. Thank you Ashley. 

[Ashley Hudson]

Sweet! Glad I could help! :)

[Ken Young]

I spoke to soon--- I am getting the error: 

Invalid CQL

No field exists with the name: 'status