--- title: "GET /api/database/views/{view_id}/decorations/" method: GET path: "/api/database/views/{view_id}/decorations/" tags: ["Database table view decorations"] --- # GET /api/database/views/{view_id}/decorations/ `GET /api/database/views/{view_id}/decorations/` Lists all decorations of the view related to the provided `view_id` if the user has access to the related database's workspace. A view can have multiple decorations. View decorators can be used to decorate rows. This can, for example, be used to change the border or background color of a row if it matches certain conditions. ## Path parameters - `view_id` integer, required ## Response `200` - DecoratorValueProviderTypeViewDecoration[] - union - GeneratedSingleSelectColorViewDecoration - `id` integer, required - `view` integer — The view to which the decoration applies. Each view can have his own decorations. - `type` string — The decorator type. This is then interpreted by the frontend to display the decoration. - `value_provider_type` string — The value provider type that gives the value to the decorator. - `value_provider_conf` SelectColorValueProviderConf - `field_id` integer, nullable, required — An id of a select field of the table. The value provider return the color of the selected option for each row. - `order` integer — The position of the decorator has within the view, lowest first. If there is another decorator with the same order value then the decorator with the lowest id must be shown first. - GeneratedConditionalColorViewDecoration - `id` integer, required - `view` integer — The view to which the decoration applies. Each view can have his own decorations. - `type` string — The decorator type. This is then interpreted by the frontend to display the decoration. - `value_provider_type` string — The value provider type that gives the value to the decorator. - `value_provider_conf` ConditionalColorValueProviderConfColors - `colors` ConditionalColorValueProviderConfColor[], required — A list of color items. For each row, the value provider try to match the defined colors one by one in the given order. The first matching color is returned to the decorator. - `id` string, required — A unique identifier for this condition. - `color` string, required — The color the decorator should take if the defined conditions apply. - `filters` ConditionalColorValueProviderConfColorFilter[], required — A list of conditions that the row must meet to get the selected color. This list of conditions can be empty, in that case, this color will always match the row values. - `id` string, required — A unique identifier for this condition. - `field` integer, nullable, required — The field of which the value must be compared to the filter value. - `type` union, required — Indicates how the field's value must be compared to the filter's value. The filter is always in this order `field` `type` `value` (example: `field_1` `contains` `Test`). * `equal` - equal * `not_equal` - not_equal * `filename_contains` - filename_contains * `files_lower_than` - files_lower_than * `has_file_type` - has_file_type * `contains` - contains * `contains_not` - contains_not * `contains_word` - contains_word * `doesnt_contain_word` - doesnt_contain_word * `starts_with` - starts_with * `length_is_lower_than` - length_is_lower_than * `higher_than` - higher_than * `higher_than_or_equal` - higher_than_or_equal * `lower_than` - lower_than * `lower_than_or_equal` - lower_than_or_equal * `is_even_and_whole` - is_even_and_whole * `date_equal` - date_equal * `date_before` - date_before * `date_before_or_equal` - date_before_or_equal * `date_after_days_ago` - date_after_days_ago * `date_after` - date_after * `date_after_or_equal` - date_after_or_equal * `date_not_equal` - date_not_equal * `date_equals_today` - date_equals_today * `date_before_today` - date_before_today * `date_after_today` - date_after_today * `date_within_days` - date_within_days * `date_within_weeks` - date_within_weeks * `date_within_months` - date_within_months * `date_equals_days_ago` - date_equals_days_ago * `date_equals_months_ago` - date_equals_months_ago * `date_equals_years_ago` - date_equals_years_ago * `date_equals_week` - date_equals_week * `date_equals_month` - date_equals_month * `date_equals_day_of_month` - date_equals_day_of_month * `date_equals_year` - date_equals_year * `date_is` - date_is * `date_is_not` - date_is_not * `date_is_before` - date_is_before * `date_is_on_or_before` - date_is_on_or_before * `date_is_after` - date_is_after * `date_is_on_or_after` - date_is_on_or_after * `date_is_within` - date_is_within * `single_select_equal` - single_select_equal * `single_select_not_equal` - single_select_not_equal * `single_select_is_any_of` - single_select_is_any_of * `single_select_is_none_of` - single_select_is_none_of * `link_row_has` - link_row_has * `link_row_has_not` - link_row_has_not * `link_row_contains` - link_row_contains * `link_row_not_contains` - link_row_not_contains * `boolean` - boolean * `empty` - empty * `not_empty` - not_empty * `multiple_select_has` - multiple_select_has * `multiple_select_has_not` - multiple_select_has_not * `multiple_collaborators_has` - multiple_collaborators_has * `multiple_collaborators_has_not` - multiple_collaborators_has_not * `user_is` - user_is * `user_is_not` - user_is_not * `has_value_equal` - has_value_equal * `has_not_value_equal` - has_not_value_equal * `has_value_contains` - has_value_contains * `has_not_value_contains` - has_not_value_contains * `has_value_contains_word` - has_value_contains_word * `has_not_value_contains_word` - has_not_value_contains_word * `has_value_length_is_lower_than` - has_value_length_is_lower_than * `has_all_values_equal` - has_all_values_equal * `has_empty_value` - has_empty_value * `has_not_empty_value` - has_not_empty_value * `has_any_select_option_equal` - has_any_select_option_equal * `has_none_select_option_equal` - has_none_select_option_equal * `has_value_lower` - has_value_lower * `has_value_lower_or_equal` - has_value_lower_or_equal * `has_value_higher` - has_value_higher * `has_value_higher_or_equal` - has_value_higher_or_equal * `has_not_value_higher_or_equal` - has_not_value_higher_or_equal * `has_not_value_higher` - has_not_value_higher * `has_not_value_lower_or_equal` - has_not_value_lower_or_equal * `has_not_value_lower` - has_not_value_lower * `has_date_equal` - has_date_equal * `has_not_date_equal` - has_not_date_equal * `has_date_before` - has_date_before * `has_not_date_before` - has_not_date_before * `has_date_on_or_before` - has_date_on_or_before * `has_not_date_on_or_before` - has_not_date_on_or_before * `has_date_on_or_after` - has_date_on_or_after * `has_not_date_on_or_after` - has_not_date_on_or_after * `has_date_after` - has_date_after * `has_not_date_after` - has_not_date_after * `has_date_within` - has_date_within * `has_not_date_within` - has_not_date_within - … - `value` string — The field of which the value must be compared to the filter value. - `group` string, nullable — The id of the filter group this filter belongs to. If this is null, the filter is not part of a filter group. - `filter_groups` ConditionalColorValueProviderConfColorFilterGroup[] — A list of filter groups that the row must meet to get the selected color. - `id` string, required — A unique identifier for this condition. - `filter_type` 'AND' | 'OR' — * `AND` - And * `OR` - Or - `parent_group` string, nullable — The id of the parent filter group. - `operator` 'AND' | 'OR' — * `AND` - And * `OR` - Or - `order` integer — The position of the decorator has within the view, lowest first. If there is another decorator with the same order value then the decorator with the lowest id must be shown first. ## Other responses - `400` - `404` --- [API](https://skmtc.dev/baserow/apis/baserow-api-spec.md) · [All operations](https://skmtc.dev/baserow/apis/baserow-api-spec/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/baserow/baserow-api-spec/revisions/f3396317d932/schema)