Spaces
Returns information about a number of spaces.
Table Specific Information
Select
The add-in 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 add-in. 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. |