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'
Columns
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. |
Pseudo-Columns
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. |