GeneralSettings
Update and Query the General Settings in kintone.
Select
The AppId column is required in the WHERE clause. The add-in will use the Kintone APIs to filter the results by this column. By default, the add-in will process other filters client-side within the add-in.
For example, the following queries are processed server side:
SELECT * FROM GeneralSettings WHERE AppId = 6 SELECT * FROM GeneralSettings WHERE AppId = 6 AND IsPreview = false
Update
You must specify the AppId and IconKey of the GeneralSetting to update.
UPDATE GeneralSettings SET Name = 'UpdatedName', Description = 'Test Description', IconType = 'PRESET', IconKey = 'APP72' WHERE IconKey = 'APP72' AND AppId = 6
Columns
| Name | Type | ReadOnly | References | Description |
| AppId [KEY] | Integer | True |
The App ID of the kintone application. | |
| IconKey [KEY] | String | False |
The key identifier of the icon. Responded, if the preset icons within Kintone are used. | |
| IconType | String | False |
The icon type: FILE, PRESET. | |
| IconFile | String | False |
The icon type: FILE, PRESET. | |
| Name | String | False |
The App name. | |
| Description | String | False |
The app description in HTML format. | |
| Theme | String | False |
The color theme. | |
| 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 General Settings details of the live App. Default value is true. |