GetValidTerms
Retrieves a list of valid managed metadata terms associated with a specific column in a SharePoint list. Helps enforce consistent categorization and tagging of SharePoint content.
Table Specific Information
GetValidTerms is a special view used to retrieve valid terms for a taxonomy or managed metadata column in a given Microsoft SharePoint list. To query this view, you must provide both the List and ColumnName columns.
Sample Query
The following query retrieves valid terms for the TermsC column in the list1 list:
SELECT * FROM GetValidTerms WHERE List = 'list1' AND ColumnName = 'TermsC';
Columns
| Name | Type | Description |
| ID [KEY] | String | A unique identifier for the term. Useful for referencing and managing taxonomy terms in SharePoint. |
| TermLabelValue | String | The label assigned to the term. Helps users identify and apply terms to content. |
| Description | String | A brief description of the term set. Useful for understanding the purpose and usage of the term set. |
| NameInRequestedLang | String | The name of the term set in the language requested by the client. Helps with multilingual support. |
| IsOpen | Boolean | Indicates whether the term set is open for adding new terms. Useful for managing controlled vocabularies. |
| Deprecated | Boolean | Indicates whether the term is deprecated. Helps prevent usage of outdated or obsolete terms. |
| InternalId | String | An internal identifier for the term. Useful for system-level term management. |
| TermSetContact | String | The contact person or group responsible for managing the term set. Useful for governance and support. |
| ContainerDesc | String | A container node that holds metadata descriptions. Helps structure taxonomy information. |
| SingleTermLabelDesc | String | A detailed description of a single term label. Useful for providing additional context. |
| IsDefaultLabel | Boolean | Indicates whether the term label is the default for the term. Helps standardize term usage. |
| BelongsTo | String | The term set to which this term belongs. Useful for managing hierarchical taxonomies. |
| IsTaggingAvailable | Boolean | Indicates whether the term set is available for tagging. Helps control content classification. |
| TermPath | String | The hierarchical path of the term with term labels. Useful for navigating term relationships. |
| TermpathoftermwithIds | String | The hierarchical path of the term with its unique identifiers. Helps track term lineage. |
| ChildTerms | String | A custom sort order for child terms within the term hierarchy. Useful for organizing terms. |
| HasChildTerms | Boolean | Indicates whether the term has child terms. Helps manage nested taxonomy structures. |
| PertainingToTerm | String | The identifier of the term that this term set information pertains to. Useful for hierarchical organization. |
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 SharePoint list for which valid terms are being retrieved. Helps with taxonomy integration. |
| ColumnName | String | The column in the list for which valid terms are being retrieved. Useful for metadata enforcement. |
| LocaleId | String | The locale ID for the term. Defaults to 1033 (English). Helps support multilingual taxonomy. |