GetValidTerms

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.