GraphSettings
Manages the charts and analytics defined inside an app so administrators can review or update how data is visualized for users.
Select
WHERE 句ではAppId カラムが必須です。本製品 はKintone API を使用してこのカラムによる結果をフィルタリングします。デフォルトでは、本製品 はクライアント側で本製品 内で他のフィルタを処理します。
例えば、次のクエリはサーバー側で処理されます。
SELECT * FROM GraphSettings WHERE AppId = 6 SELECT * FROM GraphSettings WHERE AppId = 6 AND Lang = 'en' SELECT * FROM GraphSettings WHERE AppId = 6 AND IsPreview = false
Update
GraphSettings を更新するには、Reports を集計として指定します。GraphSettings を更新するには、AppId カラムが必須です。
UPDATE GraphSettings SET Reports = '{"Graph1":{"chartType":"BAR","chartMode":"PERCENTAGE","name":"Updated_Graph_Name","index":"0","groups":[{"code":"Created_by"}]}}' WHERE AppId = 6
Columns
| Name | Type | ReadOnly | References | Description |
| AppId | Integer | False |
Identifier of the Kintone app whose graph and reporting settings are being retrieved or updated. | |
| Id [KEY] | String | True |
Unique identifier of the graph configuration within the app. | |
| Index | String | False |
Zero-based position of the graph in the app's graph list, determining the order in which graphs appear to users. | |
| Name | String | False |
Display name of the graph, limited to 64 characters, and returned in the requested language when a lang parameter is provided. | |
| PeriodicReport | String | False |
Object containing the graph's periodic report settings, returned as 'null' when no periodic report has ever been configured. | |
| Sorts | String | False |
Array of objects defining the Sort by settings that determine how graph data is ordered. | |
| Aggregations | String | False |
Function settings used to aggregate field values, such as totals or counts, when generating the graph. | |
| ChartMode | String | False |
Display mode applied to the graph, determining how the chart is rendered in the interface. | |
| ChartType | String | False |
Chart type selected for the graph, such as bar, line, pie, or other supported visualization formats. | |
| FilterCond | String | False |
Record filter condition expressed in query-string format, reflecting the graph's Filter settings. | |
| Groups | String | False |
Function settings used for grouping records in the graph, defining how data is categorized during aggregation. | |
| Revision | String | True |
Revision number of the app settings, helping track updates made to graph configurations. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるデータを詳細に制御することができます。
| Name | Type | Description |
| Lang | String |
Locale code used to retrieve graph-setting values in a specific language. |
| IsPreview | Boolean |
Indicates whether to retrieve graph-setting details from the preview environment ('true') or from the live environment ('false'). The default value is 'true'. |
| Reports | String |
Value used only when performing an update to supply modified graph-report settings. |