Labels
Returns the labels associated with a specific piece of content, helping categorize and organize information within Confluence.
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.
Note: Either ContentId, LabelName or ContentType must be specified in order to query the Labels view.
- ContentId supports the '=,!=,IN,NOT IN' comparisons.
- LabelName supports the '=,IN' comparisons.
- ContentType supports the '=,!=,IN,NOT IN' comparisons.
For example, the following queries are processed server side:
SELECT * FROM Labels WHERE ContentId = '1234'
SELECT * FROM Labels WHERE ContentId! = '1234'
SELECT * FROM Labels WHERE ContentId IN ('1234', '2345')
SELECT * FROM Labels WHERE ContentId NOT IN ('1234', '2345')
SELECT * FROM Labels WHERE LabelName = 'test'
SELECT * FROM Labels WHERE LabelName IN ('test1', 'test2')
SELECT * FROM Labels WHERE ContentType = 'page'
SELECT * FROM Labels WHERE ContentType != 'page'
SELECT * FROM Labels WHERE ContentType IN ('page', 'attachment')
SELECT * FROM Labels WHERE ContentType NOT IN ('page', 'attachment')
Additionally, ContentId column can be used in the ORDER BY clause, as following:
SELECT * FROM Labels ORDER BY ContentId DESC
Columns
| Name | Type | References | SupportedOperators | Description |
| ContentId [KEY] | String | =,!=,IN,NOT_IN | The unique identifier of the content item that supports labels, such as a page, attachment, or blog post. This value corresponds to the 'Id' field in related tables like Attachments, Pages, or Blogposts. | |
| ContentType | String | =,!=,IN,NOT_IN | Specifies the type of content associated with the label, such as page, attachment, or blog post. | |
| LabelId [KEY] | String | The unique identifier of the label assigned to the content. | ||
| LabelName | String | =,IN | The name of the label applied to the content, used for categorization and search filtering. | |
| LabelPrefix | String | Defines the prefix associated with the label, which indicates its scope or origin, such as global or team-specific. |