Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

CQL function()DescriptionExample
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/

Examples

Pages CQL

Display the user's favorite pages

...

See example below under the "my favourite pages' section in image. 

...

UI Text Box
siteSearch ~ "$username*" and mention = currentUser()

...

News CQL

Get all blog posts from a site

...

UI Text Box
type = blogpost AND refinedSite = 123 ORDER BY created DESC

Get all blog posts from a category

...

UI Text Box
type = blogpost AND refinedCategory = hr ORDER BY created DESC


Get all blog posts added by the current logged in user

...

UI Text Box
typetip

Tip: Text Variables can be used to construct CQL queries. 

...

UI Text Box
type = blogpost AND creator = $username ORDER BY created DESC

Get all blogposts from the blog site

...

UI Text Box
type = blogpost AND space IN blogSite() ORDER BY created DESC

...

UI Text Box
typetip

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)

UI Text Box
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*"

...

UI Text Box
text ~"*$query*"

...

You are evaluating Refined.