Tableau Connector for Confluence

Build 21.0.7930

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.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930