Skip to content

items

Overview

This object is used to create, read, update, delete, etc. "records" in "Server Script". The "model object" can only handle the current record, but the "items object" can handle any record by specifying its ID.

Cautions

  1. When "Server Script" performs I/O of "records", the processing load on the server side may increase. If the execution time of "Server Script" exceeds the specified processing timeout, the process will stop due to a timeout and an "Application Error" will occur. The timeout can be adjusted in "ServerScriptTimeOut" in "Script.json".

Limitations

  1. Operations without access rights cannot be performed. For example, if a script is written to perform a read operation on record ID 10, the record cannot be retrieved if accessed by a user who does not have read permission for record ID 10.

Properties

It has no properties.

Methods

No Name Description
1 Average Gets the average value of the "Numeric Value" columns of "records".
2 BulkDelete Deletes "records" in bulk.
3 Count Gets the number of "records".
4 Create Creates "records".
5 Delete Deletes "records".
6 Get Gets an array of "apiModel" objects that match the specified conditions.
7 GetClosestSite Gets the site information of the site closest to the current site by specifying the site name.
8 GetSite Gets site information by specifying the site ID.
9 GetSiteByGroupName Gets site information by specifying the site group name of the site.
10 GetSiteByName Gets site information by specifying the site name of the site.
11 GetSiteByTitle Gets site information by specifying the title of the site.
12 Max Gets the maximum value of the "Numeric Value" columns of "records".
13 MaxDate Gets the maximum value of the "Date" columns of "records".
14 Min Gets the minimum value of the "Numeric Value" columns of "records".
15 MinDate Gets the minimum value of the "Date" columns of "records".
16 NewIssue Creates a new instance of the "apiModel" object for a "time-limited table".
17 NewResult Creates a new instance of the "apiModel" object for a "recorded table".
18 NewSite Creates a new instance of the "apiModel" object for a "site".
19 Sum Gets the sum of the "Numeric Value" columns of "records".
20 Update Updates "records".
21 Upsert If a "record" that matches the key column exists in the specified site, updates it; otherwise, creates a new one.
22 New (deprecated) Creates a new instance of the "apiModel" object for a "time-limited table".