BoardViews
Fetches a list of views configured for a specific board.
Table-Specific Information
SELECT
The server uses the Monday API to process some of the filters. The server processes other filters client-side within the server.
- Id supports the '=','IN' comparison operators.
- BoardId supports the '=','IN' comparison operators.
- Type supports the '=' comparison operator.
For example, the following queries are processed server-side:
SELECT * FROM BoardViews WHERE Id = 'Val1'
SELECT * FROM BoardViews WHERE BoardId = 'Val1'
SELECT * FROM BoardViews WHERE Type = 'Val1'
INSERT
The following columns can be used to create a new record:
BoardId, Name, Settings, Type, FilterTeamId, FilterUserId, Sort, Tags
The following pseudo-columns can be used to create a new record:
FilterGroups (references ViewQueryGroup), FilterOperator, FilterRules (references ViewQueryRule)
ViewQueryGroup Temporary Table Columns
| Column Name | Type | Description |
| Groups (references ViewQueryGroup) | 115tring | The rule groups to filter your queries. |
| Operator | 115tring | The operator to use for the rule groups. |
| Rules (references ViewQueryRule) | 115tring | The rules to filter your queries. |
ViewQueryRule Temporary Table Columns
| Column Name | Type | Description |
| ColumnId | 115tring | The unique identifier of the column to filter by. |
| CompareAttribute | 115tring | The comparison attribute. |
| CompareValue | 115tring | The column value to filter by. |
| Operator | 115tring | The condition for value comparison. |
UPDATE
The following columns can be updated:
Name, Settings, Type, FilterTeamId, FilterUserId, Sort, Tags
The following pseudo-columns can be used to update a record:
FilterGroups (references ViewQueryGroup), FilterOperator, FilterRules (references ViewQueryRule)
ViewQueryGroup Temporary Table Columns
| Column Name | Type | Description |
| Groups (references ViewQueryGroup) | 115tring | The rule groups to filter your queries. |
| Operator | 115tring | The operator to use for the rule groups. |
| Rules (references ViewQueryRule) | 115tring | The rules to filter your queries. |
ViewQueryRule Temporary Table Columns
| Column Name | Type | Description |
| ColumnId | 115tring | The unique identifier of the column to filter by. |
| CompareAttribute | 115tring | The comparison attribute. |
| CompareValue | 115tring | The column value to filter by. |
| Operator | 115tring | The condition for value comparison. |
DELETE
You can delete entries by specifying the following columns:
Id, BoardId
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
A unique identifier for the board view. Used to distinguish this view from others. | |
| BoardId [KEY] | String | True |
Boards.Id |
The unique identifier of the board to which this view belongs. Links the view to its parent board. |
| Name | String | False |
The name of the board view, typically used for identification and display purposes. | |
| Settings | String | False |
The settings for the board view, stored as a string. Includes configurations specific to this view. | |
| Type | String | False |
The type of the board view, indicating its category or functionality (for example, Kanban, Calendar). | |
| ViewSpecificData | String | True |
Additional data specific to this board view. Supported only for form-based views and stored in a string format. | |
| SourceViewId | String | True |
The unique identifier of the template view if this view was created as a duplicate of another view. | |
| AccessLevel | String | True |
The user's board view access level. The allowed values are edit, view. | |
| Filter | String | True |
The view's filter metadata. | |
| FilterTeamId | String | False |
The team ID the view is filtered by. | |
| FilterUserId | String | False |
The user ID the view is filtered by. | |
| Sort | String | False |
The view's sort metadata. | |
| Tags | String | False |
The view's tags. |
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 |
| FilterGroups | String |
The rule groups to filter your queries. |
| FilterOperator | String |
The operator to use for the rule groups. The allowed values are and, or. |
| FilterRules | String |
The rules to filter your queries. |