Views
Update and Query the available Views in kintone.
Select
The AppId column is required in the WHERE clause. The connector will use the Kintone APIs to filter the results by this column. By default, the connector will process other filters client-side within the connector.
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 |
The View ID. | |
| AppId | Integer | False |
The App ID of the kintone application. | |
| Index | String | False |
The display order (ascending) of the View, when listed with other views. | |
| Name | String | False |
The name of the View. | |
| Title | String | False |
The field code set for the Title Field. Responded for Calendar Views. | |
| Type | String | False |
The type of View. The allowed values are LIST, CALENDAR, CUSTOM. | |
| BuiltinType | String | False |
The type of the built-in View. | |
| Date | String | False |
The field code set for the Date Field. Responded for Calendar Views. | |
| Fields | String | False |
The list of field codes for the fields displayed in the View. | |
| FilterCond | String | False |
The filter condition as a query. | |
| Html | String | False |
The HTML code set for the View. Responded for Custom Views. | |
| Pager | Boolean | False |
The pagination settings. Responded for Custom Views. | |
| Device | String | False |
The scope of where the view is displayed. | |
| Sort | String | False |
The sort order as a query. | |
| Revision | String | True |
The revision number of the App settings. |
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 |
The localized language to retrieve the data. |
| IsPreview | Boolean |
By setting this to False, you will be able to retrieve the Views details of the live App. Default value is true. |
| Views | String |
Only used for performing Update. |