Spaces
Returns information about a number of spaces.
Table Specific Information
Select
The connector 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 connector. 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:
SQL
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'
CQL
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'
Columns
| Name | Type | ReadOnly | References | SupportedOperators | Description |
| Id | String | True |
Id of the space. | ||
| Key [KEY] | String | False | =,!=,IN,NOT_IN |
Unique key of the space. | |
| Name | String | False | =,!= |
Name of the space. | |
| IconPath | String | True |
Path of the space icon. | ||
| IconWidth | Integer | True |
Width of the space icon. | ||
| IconHeight | Integer | True |
Height of the space icon. | ||
| IsIconDefault | Boolean | True |
Indicator if the icon is default. | ||
| Excerpt | String | True |
Excerpt of the space. | ||
| Type | String | False | =,!=,IN,NOT_IN |
Type of the space. | |
| Url | String | True |
Url of the space. | ||
| LastModified | Datetime | True |
Last modified datetime. | ||
| ItemURL | String | True |
The URL reference of the element in UI. | ||
| Description | String | False |
Description of the space. | ||
| CreatedDate | Datetime | True | =,>,>=,<,<= |
Datetime for the creation of the content. | |
| Alias | String | False |
Identifier for the space in confluence page URLs. | ||
| Status | String | False |
Status of the space. |
Pseudo-Columns
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. |