Search for space by title, using CQL?

[aragot]

I’m trying to find a space by title, using CQL, with type = 'space' and title ~ 'word'. But:

• In CQL, type = 'space' isn’t a correct value ([https://developer.atlassian.com/server/confluence/cql-field-reference/#type](https://see doc)), the only accepted values are page, blogpost, comment, attachment.
• com.atlassian.confluence.api.model.content.ContentType doesn’t have a value for “space”.

Is it possible to search for spaces with CQL? If not, is it possible to search for “all spaces starting with…” in Confluence Server?

[DaveLiao]

@aragot try an advanced search space.title ~ "cats"

That will return any spaces with “cats” in its name. It’s not a “starts with” search, but gets you closer to what you’re looking for.

[aragot]

Thank you for the suggestion, but I have a space named “Team” and the CQL space.title ~ "Team" doesn’t return any result through the Java API. It does return something through the Confluence search.

Found the answer! One needs to call .search() and not .searchContent():

cqlSearchService.search(
    "type = \"space\" and title ~ \"Tea*\"",
    searchOptions, new SimplePageRequest(0, 20)
).getResults()

returns the space Team (and title ~ "Tea" doesn’t, so the * is actually useful).

[DaveLiao]

Woohoo! Glad you figured it out (and shared the solution)

[aragot]

Sorry for not marking yours as the solution, which doesn’t give you the points

[DaveLiao]

haha, my solution wasn’t the solution to your problem, so it’s all good.