Confluence CQL examples: a super-useful collection

[Levente Szabo _Midori_]

TL, DR: The team at Midori published a super-useful collection of CQL query examples. These help you specify the contents to be processed in your page status, notification, or automation schemes.

Share your thoughts below in the comments and browse CQL examples >>

---

CQL for Confluence page status and more

Confluence Query Language (CQL) is the powerful search option in Confluence. It's also very hard to access since Confluence doesn't natively have a user interface for it.

Advanced Confluence apps, like Better Content Archiving, use CQL, so it's important to know what's possible with it.
In Better Content Archiving, you can use CQL to specify what pages:

• should go to a certain status
• to send out in notification emails
• to archive or delete

We published a broad list of useful CQL query examples that you can copy with a click.
Browse the list and find out how to use CQL for Confluence page status and to search for:

• Contents in a certain space and a certain status
• Contents that changed status in the last 24 hours
• Contents in a certain status where this status changed in the past week
• Contents last viewed by a user (or me)
• Contents not viewed in the last 100 days
• Contents last updated by a user (or me)
• Contents owned by a user (or me)
• Contents without an owner
• Expired content
• Contents without an expiration date
• Contents with an expiration date set by a specific user
• Contents archived this week
• AND MANY MORE!

Click here and browse Confluence CQL examples >>

Where exactly can you use these?

CQL expressions come into play when you are configuring your notification, page status, or content automation schemes (e.g. for auto-archiving):

Continue learning about:

1. Configuring automatic Confluence page statuses
2. Setting up automatic page notifications and reminders
3. Building content automations or page archiving and deletion (VIDEO)
4. New Confluence CQL fields added by Better Content Archiving