Useful CQLs

For more information, visit Advanced Searching Using CQL


Find content within the current space

1 text ~ $$query$$ and space = $$space.key$$

Find content by title within the current space

1 title ~ $$query$$ and space = $$space.key$$

Find content that has mentioned the current user

1 text ~ $$query$$ and mention = currentUser()

Find content in the current space that mentions the given user

1 space = $$space.key$$ and mention = $$query$$

Find page that is favourited by the current user

1 favorite = currentUser() and type = page

Find content that are contributed by the given user since past week

1 contributor = $$query$$ and lastModified > startOfWeek("-1w") and type not in (comment,attachment) order by type desc
  • For this to work, please set the Search Type to Exact Match

Find content that has the CQL navigation macro

1 macro = cqlnavigation order by title asc

Macro Display Name

Macro name

Macro Display Name

Macro name

CQL Search

cqlsearch

CQL Search Table

cqlsearchtable

CQL Search Counter (Board)

cqlsearchcounter

CQL Search Counter (Link)

cqlsearchcounterlink

CQL Navigation

cqlnavigation

Contributor Summary Report

cqlsummary

Two Dimensional Contributor Report

cqlsummaryreport

CQL Quick Search

cqltab

Display pages within the current space that do not have any label

1 sitesearch ~ "type:page AND NOT (labelText:[a TO z] OR labelText:[0 TO 9]) AND spacekey:$$space.key$$"

Appendix A - List of Placeholder variables

Placeholder

Description

Placeholder

Description

$$space.key$$

The key of the current space

$$space.title$$

The title of the current space

$$id$$

The id of the current page

$$parentid$$

The key of the parent page

$$title$$

The title of the current page

$$created$$

The created date of the current page

$$lastmodified$$

The last modified date of the current page