User Manual

07.28.2025

MANUAL

Developer Function: Server Script: items.MinDate

## Overview This is the "MinDate Method" of the "「items Object」". It gets the date value of the target date 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 "「Date Column」". ## Syntax ``` items.MinDate(siteId, columnName, view) ``` ## Parameters |Parameter|Type|Required|Description| |:----------|:----------|:---:|:---------------------------| |siteId|object|Yes|Specify the site ID of the target table| |columnName|string|Yes|Specify the date 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 date column in the target table. If the specified specified date value column is not found 「utilities.EmptyTime」 is returned. ## Usage Example 1 The following example gets the minimum value of DateA in the table with site ID 2. ##### JavaScript ``` let minDate = items.MinDate(2, 'DateA'); ``` ## Usage Example 2 The following example gets the minimum value of DateA for the record whose Status is 900 (completed) in the table with site ID 2. ##### JavaScript ``` let view = { "View": { "ColumnFilterHash": { "Status": "[\"900\"]" } } }; let minDate = items.MinDate(2, 'DateA', JSON.stringify(view)); context.Log(minDate); ``` ## 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.