JDBC Driver for Confluence

Build 22.0.8462


Returns information about a number of spaces.

Table Specific Information


The driver will use the Confluence API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the driver. You can also search for Attachments using CQL (Confluence Query Language).

  • Key supports the '=,!=,IN,NOT IN' comparisons.
  • Name supports the '=,LIKE,NOT LIKE' comparisons.
  • Type supports the '=,!=,IN,NOT IN' comparisons.
  • Excerpt supports the '=' comparisons.

For example, the following queries are processed server side:


SELECT * FROM Spaces WHERE Key = 'abc'

SELECT * FROM Spaces WHERE Name IN ('name1','name2')

SELECT * FROM Spaces WHERE Excerpt = 'driver development'

SELECT * FROM Spaces WHERE Key = 'abc' AND Type = 'global'


Note: Filtering with CQL has the highest priority and all the other filters except "Excerpt" will be ignored when CQL filter is present in the query.

SELECT * FROM Spaces WHERE CQL = 'type = space AND space.title~"Driver Development"' AND Excerpt = 'indexed'


Name Type References SupportedOperators Description
Id String Id of the space.
Key [KEY] String =,!=,IN,NOT IN Unique key of the space.
Name String =,LIKE,NOT LIKE Name of the space.
IconPath String Path of the space icon.
IconWidth Integer Width of the space icon.
IconHeight Integer Height of the space icon.
IsIconDefault Boolean Indicator if the icon is default.
Excerpt String = Excerpt of the space.
Type String =,!=,IN,NOT IN Type of the space.
Url String Url of the space.
LastModified Datetime Last modified datetime.


Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
CQL String CQL (Confluence Query Language) allows you to build structured queries.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462