User Manual

05.16.2025

MANUAL

Developer Function: Server Script: items.Sum

## Overview This is the "Sum Method" of the "「Items Object」". It gets the sum of the target numeric value column in the specified table. You can specify selection conditions to narrow down the records to be aggregated. ## Limitations 1. Cannot be used for anything other than "「Numeric Value Column」". ## Syntax ``` items.Sum(siteId, columnName, view) ``` ## Parameters |Parameter|Type|Required|Description| |:----------|:----------|:---:|:---------------------------| |siteId|object|Yes|Specify the site ID of the target table| |columnName|string|Yes|Specify the numeric value column to be calculated| |view|string|No|Specify the conditions for the records to be selected| ## Return Value Return the total value of the specified numeric value column in the target table. ## Usage Example The following example gets the sum of NumA in the table with site ID 2. ##### JavaScript ``` let sum = items.Sum(2, 'NumA'); ``` The following example gets the sum of the NumA values of the records in the table with site ID 2 and Status of 900 (completed). ``` let view = { "View": { "ColumnFilterHash": { "Status": "[\"900\"]" } } }; let sum = items.Sum(2, 'NumA', JSON.stringify(view)); context.Log(sum); ``` ## Related Information <div id="ManualList"> <article class="s-blog_list_unit"><h2> <h2>The specified information was not found.</h2> <p><a href="/ja/manual">Return to top</a></p> </article> </div><input id="SearchTextHidden" type="hidden" value="" />
TOP
このページをシェアする
記載された商品名、各製品名は各社の登録商標または商標です。 © Implem Inc.