JDBC Driver for Monday

Build 25.0.9539

BoardViews

Fetches a list of views configured for a specific board.

Table-Specific Information

SELECT

The driver uses the Monday API to process some of the filters. The driver processes other filters client-side within the driver.

  • 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 NameTypeDescription
Groups (references ViewQueryGroup)115tringThe rule groups to filter your queries.
Operator115tringThe operator to use for the rule groups.
Rules (references ViewQueryRule)115tringThe rules to filter your queries.

ViewQueryRule Temporary Table Columns

Column NameTypeDescription
ColumnId115tringThe unique identifier of the column to filter by.
CompareAttribute115tringThe comparison attribute.
CompareValue115tringThe column value to filter by.
Operator115tringThe 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 NameTypeDescription
Groups (references ViewQueryGroup)115tringThe rule groups to filter your queries.
Operator115tringThe operator to use for the rule groups.
Rules (references ViewQueryRule)115tringThe rules to filter your queries.

ViewQueryRule Temporary Table Columns

Column NameTypeDescription
ColumnId115tringThe unique identifier of the column to filter by.
CompareAttribute115tringThe comparison attribute.
CompareValue115tringThe column value to filter by.
Operator115tringThe 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.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 25.0.9539