ADO.NET Provider for Confluence

Build 21.0.7930

Labels

Get information about the labels that a specific content has.

Table Specific Information

Select

The {i 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 {i.

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