Views
Controls the app views that define filtered, sorted, or custom-formatted record lists, supporting administration of user-facing data presentations.
Select
The AppId column is required in the WHERE clause. The server will use the Kintone APIs to filter the results by this column. By default, the server will process other filters client-side within the server.
For example, the following queries are processed server side:
SELECT * FROM Views WHERE AppId = 6 SELECT * FROM Views WHERE AppId = 6 AND Lang = 'en' SELECT * FROM Views WHERE AppId = 6 AND IsPreview = false
Update
For updating the Views, provide the Views as an aggregate. View names that are not stated in the aggregate will be deleted. The AppId column is required to update the Views.
UPDATE VIEWS SET Views = '{"(Assigned to me)":{"index":0,"type":"LIST","name":"(Assigned to me)","filterCond":"Assignee in (LOGINUSER())","sort":"Record_number asc"},"subTableTest2":{"index":1,"type":"CALENDAR","name":"subTableTest","date":"Updated_datetime","filterCond":"","sort":"Record_number asc"}}' WHERE AppId = 6
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
Identifier of the view, used to reference the specific view configuration within the app. | |
| AppId | Integer | False |
Identifier of the Kintone app that contains the view being retrieved or updated. | |
| Index | String | False |
Ascending display order of the view, determining its position relative to other views in the app. | |
| Name | String | False |
Display name of the view as presented to users in the Kintone interface. | |
| Title | String | False |
Field code used as the title field when displaying calendar views, returned only for calendar-type views. | |
| Type | String | False |
Type of view, such as list, calendar, or custom, defining how records are presented to the user. The allowed values are LIST, CALENDAR, CUSTOM. | |
| BuiltinType | String | False |
Indicates the type of built-in view being used when the view is not custom. | |
| Date | String | False |
Field code used as the date field for calendar views, returned only when the view is configured as a calendar view. | |
| Fields | String | False |
List of field codes that determine which fields appear in the view's record list. | |
| FilterCond | String | False |
Filter condition expressed as a query string, defining which records appear in the view. | |
| Html | String | False |
HTML content used to render a custom view, returned only when the view is defined as a custom layout. | |
| Pager | Boolean | False |
Indicates whether pagination is enabled for the view, returned only for custom views. | |
| Device | String | False |
Specifies the device contexts where the view is displayed, such as desktop or mobile. | |
| Sort | String | False |
Sort order expressed as a query string, defining how records are ordered within the view. | |
| Revision | String | True |
Revision number of the app settings, helping track updates made to the view configuration. |
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 |
| Lang | String |
Locale code used to retrieve view details in a specific language. |
| IsPreview | Boolean |
Indicates whether to retrieve view details from the preview environment ('true') or from the live environment ('false'). The default value is 'true'. |
| Views | String |
Value used only when performing an update to supply modified view settings. |