SSIS Components for Microsoft SharePoint

Build 23.0.8839


Gets a list of valid terms for the specified column on the specified table.


GetValidTerms は特別なビューです。これを使用して、特定のリストの分類列または管理されたメタデータ列に対して有効な用語を取得できます。このビューを使用するには、テーブルの名前と、有効な用語の取得元になる列を指定します。次に例を示します。

SELECT * FROM GetValidTerms WHERE List = 'MyListName' AND ColumnName = 'MyManagedMetadataColumn'


Name Type Description
ID [KEY] String The identifier of the term.
TermLabelValue String The label of the term.
Description String Description of the term set.
NameInRequestedLang String The name of the term set in the language requested by the client.
IsOpen Boolean A Boolean indicating if the term set is open.
Deprecated Boolean A Boolean indicating if the term is deprecated.
InternalId String An internal identifier for the term.
TermSetContact String The term set contact.
ContainerDesc String The container node for the description.
SingleTermLabelDesc String This fully describes a single term label.
IsDefaultLabel Boolean True if the term label is the default term label.
BelongsTo String This item describes a term set to which a term belongs.
IsTaggingAvailable Boolean If the term set is available for tagging, this value is true.
TermPath String Term path of the term with term labels.
TermpathoftermwithIds String Term path of term with identifiers.
ChildTerms String A string value that indicates a custom sort order for the child terms of the term identified by PertainingToTerm.
HasChildTerms Boolean True if the term has child terms.
PertainingToTerm String An identifier of the term that this term set information is pertaining to.


SELECT ステートメントのWHERE 句では、疑似列フィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
List String The name of the list to get valid terms for.
ColumnName String The name of the column to get valid terms for.
LocaleId String The locale Id for the term. Defaults to 1033.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839