The following modules are powered by CQL: News, Activity, Search and Pages
Sites and categories introduced by RefinedTheme can be used in a CQL statement.
|refinedSite||number||The site id. You can find the site Id in the Site Builder. Click edit on a site and take the site id from the url.||refinedSite = 123|
|refinedCategory||string||The category key.||refinedCategory = hr|
|blogs()||Returns all spaceKeys for spaces marked as 'Blog spaces'|
type = blogpost AND space IN blogs()
|blogSite()||Returns all spaceKeys for spaces placed in the Blog Site|
type = blogpost AND space IN blogSite()
Atlassian CQL Documentation
Read this document to learn more about CQL: https://developer.atlassian.com/server/confluence/advanced-searching-using-cql/
Display the user's favorite pages
See example below under the "my favourite pages' section in image.
favorite = currentUser() and type = page
List all my mentions
siteSearch ~ "$username*" and mention = currentUser()
Get all blog posts from a site
type = blogpost AND refinedSite = 123 ORDER BY created DESC
Get all blog posts from a category
type = blogpost AND refinedCategory = hr ORDER BY created DESC
Get all blog posts added by the current logged in user
type = blogpost AND creator = $username ORDER BY created DESC
Get all blogposts from the blog site
type = blogpost AND space IN blogSite() ORDER BY created DESC
Get all blogposts from blog spaces
type = blogpost AND space IN blogs() ORDER BY created DESC
You can also make use of any third-party CQL additions as well (RefinedTheme 6.1).
Tailoring the search with CQL
Search Confluence Questions for questions or answers (RefinedTheme 6.1)
type = "com.atlassian.confluence.plugins.confluence-questions:answer" or type = "com.atlassian.confluence.plugins.confluence-questions:question"
Search all content using the CQL: text ~"*$query*"
Search Confluence for users
siteSearch ~ "$query*" and type = user
Search my mentions
siteSearch ~ "$query*" and mention = currentUser()
Search all content within a space using the CQL
text ~"*$query*" and space.key=$spacekey