ColumnTypeSchema
The schema for a specific column type.
View-Specific Information
SELECT
The provider uses the Monday API to process some of the filters. The provider processes other filters client-side within the provider.
- Type supports the '=','IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM ColumnTypeSchema WHERE Type = 'auto_number'
SELECT * FROM ColumnTypeSchema WHERE Type IN ('auto_number','board-relation')
Columns
| Name | Type | References | Description |
| JSON | String | The column schema JSON object. | |
| Type [KEY] | String | The type of the column.
The allowed values are auto_number, board_relation, button, checkbox, color_picker, country, creation_log, date, dependency, doc, dropdown, email, file, formula, group, hour, integration, item_assignees, item_id, last_updated, link, location, long_text, mirror, name, numbers, people, person, phone, progress, rating, status, subtasks, tags, team, text, time_tracking, timeline, unsupported, vote, week, world_clock. |