Labels
Get information about the labels that a specific content has.
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: ContentId is required in order to query the Labels view.
- ContentId supports the '=,!=,IN,NOT IN' comparisons.
- LabelName 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 != 'test'
SELECT * FROM Labels WHERE LabelName IN ('test1', 'test2')
SELECT * FROM Labels WHERE LabelName NOT IN ('test1', 'test2')
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 | This is the Id of the content that support labels. This can be referenced from Attachments.Id, Pages.Id, or Blogposts.Id. | |
| LabelId | String | Id of the label. | ||
| LabelName | String | =,!=,IN,NOT IN | Name of the label. | |
| LabelPrefix | String | Prefix of the label. |