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 |
An object containing data of uploaded icon files. | |
| 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. | |
| TitleFieldSelectionMode | String | False |
The option of The field to be used as the record title settings: AUTO, MANUAL. | |
| TitleFieldCode | String | False |
The field code of the field used as the title of the record. | |
| EnableBulkDeletion | Boolean | False |
The Enable bulk deletion of records setting. | |
| EnableComments | Boolean | False |
The Enable comments setting. | |
| EnableDuplicateRecord | Boolean | False |
The Enable the feature to | |
| EnableThumbnails | Boolean | False |
The Show thumbnails setting. | |
| FirstMonthOfFiscalYear | Integer | False |
The First month of Fiscal Year setting. The number of the month will be returned. | |
| NumberPrecisionDecimalPlaces | Integer | False |
The Number of Decimal Places to Round setting. | |
| NumberPrecisionDigits | Integer | False |
The Total Number of Digits setting. | |
| NumberPrecisionRoundingMode | String | False |
The Rounding setting: HALF_EVEN, UP, DOWN. | |
| EnableInlineRecordEditing | Boolean | False |
Whether to enable inline editing in the record list |
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. |