SceneViews |
Catalog: Knack
Schema: DataDictionary
Primary Keys: id
This is a read-only table. The Knack API may not support changing the data or the Invantive UniversalSQL driver for Knack does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Knack API.
Table Columns
The columns of the table SceneViews are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
action |
varchar2 |
|
☐ |
|
address_field_key |
varchar2 |
|
☐ |
|
alert |
varchar2 |
|
☐ |
|
allow_exporting |
char |
|
☐ |
|
allow_limit |
varchar2 |
|
☐ |
|
allow_preset_filters |
char |
|
☐ |
|
application_id |
varchar2 |
Application ID |
☑ |
|
application_name |
varchar2 |
|
☑ |
|
cell_editor |
varchar2 |
|
☐ |
|
confirmation_confirmation_scene |
varchar2 |
|
☐ |
|
confirmation_confirmation_text |
varchar2 |
|
☐ |
|
confirmation_send_alert |
varchar2 |
|
☐ |
|
confirmation_type |
varchar2 |
|
☐ |
|
content |
varchar2 |
|
☐ |
|
default_range |
varchar2 |
|
☐ |
|
description |
varchar2 |
|
☐ |
|
details_filter_fields |
varchar2 |
|
☐ |
|
details_filter_type |
varchar2 |
|
☐ |
|
details_label_format |
varchar2 |
|
☐ |
|
details_layout |
varchar2 |
|
☐ |
|
details_list_layout |
varchar2 |
|
☐ |
|
details_title |
varchar2 |
|
☐ |
|
display_pagination_below |
char |
|
☐ |
|
ecommerce |
varchar2 |
|
☐ |
|
events_allow_add |
varchar2 |
|
☐ |
|
events_display_type |
varchar2 |
|
☐ |
|
events_event_color_default |
varchar2 |
|
☐ |
|
events_event_field_key |
varchar2 |
|
☐ |
|
events_ical |
varchar2 |
|
☐ |
|
events_label_field_key |
varchar2 |
|
☐ |
|
events_show_details |
varchar2 |
|
☐ |
|
events_time_max |
varchar2 |
|
☐ |
|
events_time_min |
varchar2 |
|
☐ |
|
events_view |
varchar2 |
|
☐ |
|
events_week_start |
varchar2 |
|
☐ |
|
filter_connection_sources_field_240_source_connection_key |
varchar2 |
|
☐ |
|
filter_connection_sources_field_240_source_remote_key |
varchar2 |
|
☐ |
|
filter_connection_sources_field_240_source_type |
varchar2 |
|
☐ |
|
filter_connection_sources_field_4780_source_connection_key |
varchar2 |
|
☐ |
|
filter_connection_sources_field_4780_source_remote_key |
varchar2 |
|
☐ |
|
filter_connection_sources_field_4780_source_type |
varchar2 |
|
☐ |
|
filter_fields |
varchar2 |
|
☐ |
|
filter_type |
varchar2 |
|
☐ |
|
form_title |
varchar2 |
|
☐ |
|
format |
varchar2 |
|
☐ |
|
hide_empty |
varchar2 |
|
☐ |
|
hide_fields |
varchar2 |
|
☐ |
|
id |
varchar2 |
|
☑ |
Unique ID. |
ignore_reload |
char |
|
☐ |
|
key |
varchar2 |
|
☑ |
|
keyword_search_fields |
varchar2 |
|
☐ |
|
keyword_search |
char |
|
☐ |
|
label_format |
varchar2 |
|
☐ |
|
label |
varchar2 |
|
☐ |
|
layout |
varchar2 |
|
☐ |
|
limit_profile_access |
char |
|
☐ |
|
list_layout |
varchar2 |
|
☐ |
|
list_width |
int16 |
|
☐ |
|
map_height |
int16 |
|
☐ |
|
map_width |
int16 |
|
☐ |
|
menu_links_design_active |
varchar2 |
|
☐ |
|
menu_links_design_buttons_colors_fill_background_color |
varchar2 |
|
☐ |
|
menu_links_design_buttons_colors_fill_text_color |
varchar2 |
|
☐ |
|
menu_links_design_tabs.border_thickness |
varchar2 |
|
☐ |
|
menu_links_design_tabs_border_thickness |
varchar2 |
|
☐ |
|
menu_links_design_tabs_colors_fill_background_color |
varchar2 |
|
☐ |
|
menu_links_design_tabs_colors_fill_border_color |
varchar2 |
|
☐ |
|
menu_links_design_tabs_colors_fill_border_custom |
varchar2 |
|
☐ |
|
menu_links_design_tabs_colors_fill_text_color |
varchar2 |
|
☐ |
|
menu_links_design_tabs_colors_fill_text_custom |
varchar2 |
|
☐ |
|
menu_links_design_tabs_colors_outline_text_color |
varchar2 |
|
☐ |
|
menu_links_design_tabs_format |
varchar2 |
|
☐ |
|
menu_links_design_tabs_size |
varchar2 |
|
☐ |
|
name |
varchar2 |
|
☐ |
|
no_data_text |
varchar2 |
|
☐ |
|
options_cell_editor |
varchar2 |
|
☐ |
|
parent |
varchar2 |
|
☐ |
|
pin_color_default |
varchar2 |
|
☐ |
|
registration_type |
varchar2 |
|
☐ |
|
reload_form_text |
varchar2 |
|
☐ |
|
results_label_format |
varchar2 |
|
☐ |
|
results_source_type |
varchar2 |
|
☐ |
|
results_type |
varchar2 |
|
☐ |
|
rows_per_page |
int32 |
|
☐ |
|
scene_id |
varchar2 |
|
☑ |
|
scene_key |
varchar2 |
|
☑ |
|
scene_name |
varchar2 |
|
☑ |
|
source_authenticated_user |
varchar2 |
|
☐ |
|
source_connection_key |
varchar2 |
|
☐ |
|
source_criteria_match |
varchar2 |
|
☐ |
|
source_limit |
varchar2 |
|
☐ |
|
source_object |
varchar2 |
|
☐ |
|
source_parent_source_connection |
varchar2 |
|
☐ |
|
source_parent_source_object |
varchar2 |
|
☐ |
|
source_relationship_type |
varchar2 |
|
☐ |
|
source_type |
varchar2 |
|
☐ |
|
starting_address |
varchar2 |
|
☐ |
|
starting_point |
varchar2 |
|
☐ |
|
submit_button_text |
varchar2 |
|
☐ |
|
table_design_active |
char |
|
☐ |
|
table_design_spacing |
varchar2 |
|
☐ |
|
table_design_striped |
char |
|
☐ |
|
table_design_style |
varchar2 |
|
☐ |
|
title_field_key |
varchar2 |
|
☐ |
|
title |
varchar2 |
|
☐ |
|
type |
varchar2 |
|
☐ |
|
units |
varchar2 |
|
☐ |
|
Knack API Data Model