CaseFields
Query case field definitions and their dictionary values.
Select
The CaseFields view does not push any filters to the Talkdesk API. The add-in retrieves the full result set from the endpoint and applies any WHERE clause conditions client-side.
For example:
SELECT * FROM CaseFields
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique numeric identifier of the case field. | |
| FieldKey | String | The unique key of the case field. | |
| Name | String | The name of the case field. | |
| FieldType | String | The field type code (e.g., 001=dropdown, 004=text, 006=numeric, 009=date). | |
| Description | String | A description of the case field visible to agents. | |
| DictList | String | JSON array of dictionary entries with key, value, and children. | |
| Required | Boolean | Whether agents must fill this field to solve a case. | |
| Active | Boolean | Whether the case field is active. | |
| CreatedAt | Datetime | The date and time the case field was created. | |
| UpdatedAt | Datetime | The date and time the case field was last updated. |