Labels
Returns the labels associated with a specific piece of content, helping categorize and organize information within Confluence.
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.
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. |