GetValidTerms
Gets a list of valid terms for the specified column on the specified table.
Table Specific Information
GetValidTerms is a special view. It may be used to get valid terms for a Taxonomy or Managed Metadata column of a given list. To use the view, supply both the name of the table and the column for which you are looking to get valid terms. For example:
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 | Boolean indicating if the term set is open. |
| Deprecated | Boolean | Boolean indicating if the term is deprecated. |
| InternalId | String | Internal identifier for the term. |
| TermSetContact | String | Term set contact. |
| ContainerDesc | String | 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 | Identifier of the term that this term set information is pertaining to. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| 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. |