User Manual

05.16.2025

MANUAL

Developer Function: Server Script: items.Min

## Overview This is the "Min Method" of the "「items Object」". It gets the minimum value of the target numeric value column in the specified table. You can specify selection conditions to narrow down the records to be aggregated. ## Restrictions 1. Cannot be used for anything other than "「Numeric Value Column」". ## Syntax ``` items.Min(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 minimum value of the specified numeric value column in the target table. ## Usage Example 1 The following example gets the minimum value of NumA in the table with site ID 2. ##### JavaScript ``` let min = items.Min(2, 'NumA'); ``` ## Usage Example 2 The following example gets the minimum value of NumA for the record whose Status is 900 (completed) in the table with site ID 2. ##### JavaScript ``` let view = { "View": { "ColumnFilterHash": { "Status": "[\"900\"]" } } }; let min = items.Min(2, 'NumA', JSON.stringify(view)); context.Log(min); ``` ## Notes This is a method used in "「Server Script」". It cannot be used in "「Script」". ## 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.