> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt
> Use this file to discover all available pages before exploring further.

# board_view_settings table

> Settings for selection board view

## board\_view\_settings Table (504)

Settings for selection board view

## Fields

| Name                      | Description                                                                                                                  | Type                                                        | Nullable |
| ------------------------- | ---------------------------------------------------------------------------------------------------------------------------- | ----------------------------------------------------------- | :------: |
| board\_view\_settings\_id | Primary key                                                                                                                  | PK                                                          |    No    |
| selection\_id             | The selection this board view settings belongs to                                                                            | FK [selection](./selection.mdx)                             |    Yes   |
| associate\_id             | The associate this board view settings belongs to (0 for all)                                                                | FK [associate](./associate.mdx)                             |    Yes   |
| entity\_type              | The kind of board view entity these settings belong to                                                                       | Enum [BoardViewEntityType](./enums/boardviewentitytype.mdx) |    Yes   |
| group\_by                 | Column name to group on                                                                                                      | String(255)                                                 |    Yes   |
| sub\_group\_by            | Column name to group on                                                                                                      | String(255)                                                 |    Yes   |
| sort\_by                  | Column name to sort on                                                                                                       | String(255)                                                 |    Yes   |
| sort\_desc                | True if the sort is descending                                                                                               | Bool                                                        |    Yes   |
| hide\_empty\_groups       | Do not show groups with no members/elements if this is true                                                                  | Bool                                                        |    Yes   |
| sum\_by                   | Column name to sum on                                                                                                        | String(255)                                                 |    Yes   |
| color\_by                 | Column name to color on                                                                                                      | String(255)                                                 |    Yes   |
| filters                   | Column names to filter on, comma separated                                                                                   | String(255)                                                 |    Yes   |
| settings                  | Settings that are not common to all board views. These are the unique properties of the sub carriers. Stored in json format. | Clob                                                        |    Yes   |
| registered                | Registered when                                                                                                              | UtcDateTime                                                 |    No    |
| registered\_associate\_id | Registered by whom                                                                                                           | FK [associate](./associate.mdx)                             |    No    |
| updated                   | Last updated when                                                                                                            | UtcDateTime                                                 |    No    |
| updated\_associate\_id    | Last updated by whom                                                                                                         | FK [associate](./associate.mdx)                             |    No    |
| updatedCount              | Number of updates made to this record                                                                                        | UShort                                                      |    No    |

<img src="https://mintcdn.com/superofficeas/i6M2qZmvMNH7UTeu/media/loc/en/database/tables/board_view_settings.png?fit=max&auto=format&n=i6M2qZmvMNH7UTeu&q=85&s=b2aaeeb7a35d34e5c96833ab08ad87d7" alt="board_view_settings table relationship diagram" width="705" height="59" data-path="media/loc/en/database/tables/board_view_settings.png" />

## Indexes

| Fields                                     | Types        | Description |
| ------------------------------------------ | ------------ | ----------- |
| selection\_id, associate\_id, entity\_type | FK, FK, Enum | Index       |

## Relationships

| Table                    | Description                                                        |
| ------------------------ | ------------------------------------------------------------------ |
| [associate](./associate) | Employees, resources and other users - except for External persons |
| [selection](./selection) | Selections                                                         |

## Replication Flags

* None

## Security Flags

* No access control via user's Role.


## Related topics

- [Save Board View Settings](/en/api/reference/restful/agent/selection_agent/save-board-view-settings.md)
- [Save Board View Settings For Selection And Associate](/en/api/reference/restful/agent/selection_agent/save-board-view-settings-for-selection-and-associate.md)
- [Delete Board View Settings](/en/api/reference/restful/agent/selection_agent/delete-board-view-settings.md)
- [Get Board View Settings](/en/api/reference/restful/agent/selection_agent/get-board-view-settings.md)
- [Get Board View Settings For Selection](/en/api/reference/restful/agent/selection_agent/get-board-view-settings-for-selection.md)
- [SuperOffice.WebApi.Data.BoardViewSettingsBase](/en/api/reference/webapi/SuperOffice.WebApi.Data.BoardViewSettingsBase.md)