Developer Function: Server Script
## Overview
Using "「Server Script」" allows you to execute JavaScript on the server side, enabling conditional branching, calculations, string processing, record manipulation, notifications via email or chat, dynamic access control, and more. The JavaScript execution engine used is Microsoft's [ClearScript](https://github.com/microsoft/ClearScript).
## Limitations
1. External scripts cannot be loaded.
1. Local resources such as local disks cannot be accessed.
1. DateTime values in server scripts are converted to UTC.
## Notes on Server Script Permissions
1. Server scripts are executed with the permissions of the logged-in user. If execution requires the permissions of a specific user or system administrator, you must specify that user's [API key](/manual/api-key).
## Difference Between Scripts and Server Scripts
"Server Script" allows you to manipulate on-screen data by writing JavaScript that runs in the browser, but it cannot process data during "[API](https://pleasanter.org/en/manual/api)" data updates or ["Import"](/manual/table-record-import). With "Server Script", JavaScript input/output can be performed on the server's record model, enabling data processing even during performing "[API](https://pleasanter.org/en/manual/api)" and ["Import"](/manual/table-record-import).
## Debug
You can debug "「Server Script」" using Visual Studio Code. For details, refer to [this manual](https://pleasanter.org/manual/server-script-debug).
## Operation Procedure
Please refer to "[Table Management: Server Script](table-management-server-script)".
## Related Information
<div id="ManualList"><ul><li><a href="/en/manual/server-script-debug">Developer Function: Server Script: Debug</a><span>08.14.2024 up</span></li>
<li><a href="/en/manual/server-script-functionalize">Developer Function: Server Script: Function</a><span>06.26.2025 up</span></li>
<li><a href="/en/manual/server-script-try-catch">Developer Function: Server Script: TryCatch</a><span>06.26.2025 up</span></li>
<li><a href="/en/manual/server-script-conditions">Developer Function: Server Script: Condition</a><span>08.14.2024 up</span></li>
<li><a href="/en/manual/server-script-shared">Developer Function: Server Script: Share Code</a><span>08.14.2024 up</span></li>
<li><a href="/en/manual/server-script-include">Developer Function: Server Script: Include</a><span>08.14.2024 up</span></li>
<li><a href="/en/manual/server-script-context">Developer Function: Server Script: context</a><span>12.27.2024 up</span></li>
<li><a href="/en/manual/server-script-context-add-message">Developer Function: Server Script: context.AddMessage</a><span>10.04.2024 up</span></li>
<li><a href="/en/manual/server-script-context-add-response">Developer Function: Server Script: context.AddResponse</a><span>08.14.2024 up</span></li>
<li><a href="/en/manual/server-script-context-error">Developer Function: Server Script: context.Error</a><span>10.04.2024 up</span></li>
<li><a href="/en/manual/server-script-context-forms">Developer Function: Server Script: context.Forms</a><span>10.04.2024 up</span></li>
<li><a href="/en/manual/server-script-context-query-strings">Developer Function: Server Script: context.QueryStrings</a><span>08.14.2024 up</span></li>
<li><a href="/en/manual/server-script-context-redirect">Developer Function: Server Script: context.Redirect</a><span>10.04.2024 up</span></li>
<li><a href="/en/manual/server-script-context-response-set">Developer Function: Server Script: context.ResponseSet</a><span>10.04.2024 up</span></li>
<li><a href="/en/manual/server-script-context-user-data">Developer Function: Server Script: context.UserData</a><span>08.14.2024 up</span></li>
<li><a href="/en/manual/server-script-logs">Developer Function: Server Script: logs</a><span>06.26.2025 up</span></li>
<li><a href="/en/manual/server-script-logs-log-exception">Developer Function: Server Script: logs.LogException</a><span>06.26.2025 up</span></li>
<li><a href="/en/manual/server-script-logs-log-info">Developer Function: Server Script: logs.LogInfo</a><span>06.26.2025 up</span></li>
<li><a href="/en/manual/server-script-logs-log-system-error">Developer Function: Server Script: logs.LogSystemError</a><span>06.26.2025 up</span></li>
<li><a href="/en/manual/server-script-logs-log-user-error">Developer Function: Server Script: logs.LogUserError</a><span>06.26.2025 up</span></li>
<li><a href="/en/manual/server-script-logs-log-warning">Developer Function: Server Script: logs.LogWarning</a><span>06.26.2025 up</span></li>
<li><a href="/en/manual/server-script-site-settings">Developer Function: Server Script: siteSettings</a><span>08.14.2024 up</span></li>
<li><a href="/en/manual/server-script-site-settings-sections">Developer Function: Server Script: siteSettings.Sections</a><span>10.04.2024 up</span></li>
<li><a href="/en/manual/server-script-site-settings-site-id">Developer Function: Server Script: siteSettings.SiteId</a><span>10.04.2024 up</span></li>
<li><a href="/en/manual/server-script-view">Developer Function: Server Script: view</a><span>10.04.2024 up</span></li>
<li><a href="/en/manual/server-script-view-add-column-placeholder">Developer Function: Server Script: view.AddColumnPlaceholder</a><span>10.04.2024 up</span></li>
<li><a href="/en/manual/server-script-view-always-get-columns">Developer Function: Server Script: view.AlwaysGetColumns</a><span>08.14.2024 up</span></li>
<li><a href="/en/manual/server-script-view-clear-filters">Developer Function: Server Script: view.ClearFilters</a><span>10.04.2024 up</span></li>
<li><a href="/en/manual/server-script-view-filters">Developer Function: Server Script: view.Filters</a><span>08.14.2024 up</span></li>
<li><a href="/en/manual/server-script-view-filters-cleared">Developer Function: Server Script: view.FiltersCleared</a><span>08.14.2024 up</span></li>
<li><a href="/en/manual/server-script-view-id">Developer Function: Server Script: view.Id</a><span>08.14.2024 up</span></li>
<li><a href="/en/manual/server-script-view-search-types">Developer Function: Server Script: view.SearchTypes</a><span>10.04.2024 up</span></li>
<li><a href="/en/manual/server-script-view-sorters">Developer Function: Server Script: view.Sorters</a><span>12.27.2024 up</span></li>
<li><a href="/en/manual/server-script-grid">Developer Function: Server Script: grid</a><span>10.04.2024 up</span></li>
<li><a href="/en/manual/server-script-grid-selected-ids">Developer Function: Server Script: grid.SelectedIds</a><span>08.14.2024 up</span></li>
<li><a href="/en/manual/server-script-columns">Developer Function: Server Script: columns</a><span>10.02.2025 up</span></li>
<li><a href="/en/manual/server-script-columns-add-choice-hash">Developer Function: Server Script: columns.AddChoiceHash</a><span>10.04.2024 up</span></li>
<li><a href="/en/manual/server-script-columns-clear-choice-hash">Developer Function: Server Script: columns.ClearChoiceHash</a><span>10.04.2024 up</span></li>
<li><a href="/en/manual/server-script-elements">Developer Function: Server Script: elements</a><span>08.14.2024 up</span></li>
<li><a href="/en/manual/server-script-elements-display-type">Developer Function: Server Script: elements.DisplayType</a><span>10.04.2024 up</span></li>
<li><a href="/en/manual/server-script-elements-label-text">Developer Function: Server Script: elements.LabelText</a><span>10.04.2024 up</span></li>
<li><a href="/en/manual/server-script-utilities">Developer Function: Server Scripts: utilities</a><span>08.14.2024 up</span></li>
<li><a href="/en/manual/server-script-utilities-convert-to-base64-string">Developer Function: Server Script: utilities.ConvertToBase64String</a><span>12.27.2024 up</span></li>
<li><a href="/en/manual/server-script-utilities-emptytime">Developer Function: Server Script: utilities.EmptyTime</a><span>06.26.2025 up</span></li>
<li><a href="/en/manual/server-script-utilities-maxtime">Developer Function: Server Script: utilities.MaxTime</a><span>06.26.2025 up</span></li>
<li><a href="/en/manual/server-script-utilities-mintime">Developer Function: Server Script: utilities.MinTime</a><span>06.26.2025 up</span></li>
<li><a href="/en/manual/server-script-utilities-today">Developer Function: Server Script: utilities.Today</a><span>08.14.2024 up</span></li>
<li><a href="/en/manual/server-script-utilities-inrange">Developer Function: Server Script: utilities.InRange</a><span>10.04.2024 up</span></li>
<li><a href="/en/manual/server-script-model">Developer Function: Server Script: model</a><span>09.19.2025 up</span></li>
<li><a href="/en/manual/server-script-items">Developer Function: Server Scripts: items</a><span>08.14.2024 up</span></li>
<li><a href="/en/manual/server-script-items-average">Developer Function: Server Script: items.Average</a><span>12.27.2024 up</span></li>
<li><a href="/en/manual/server-script-items-bulk-delete">Developer Function: Server Script: items.BulkDelete</a><span>10.04.2024 up</span></li>
<li><a href="/en/manual/server-script-items-count">Developer Function: Server Script: items.Count</a><span>10.04.2024 up</span></li>
<li><a href="/en/manual/server-script-items-create">Developer Function: Server Script: items.Create</a><span>10.04.2024 up</span></li>
<li><a href="/en/manual/server-script-items-delete">Developer Function: Server Script: items.Delete</a><span>10.04.2024 up</span></li>
<li><a href="/en/manual/server-script-items-get">Developer Function: Server Script: items.Get</a><span>01.30.2025 up</span></li>
<li><a href="/en/manual/server-script-items-get-closest-site">Developer Function: Server Script: items.GetClosestSite</a><span>06.09.2025 up</span></li>
<li><a href="/en/manual/server-script-items-get-site">Developer Function: Server Script: items.GetSite</a><span>10.04.2024 up</span></li>
<li><a href="/en/manual/server-script-items-get-site-by-group-name">Developer Function: Server Script: items.GetSiteByGroupName</a><span>10.04.2024 up</span></li>
<li><a href="/en/manual/server-script-items-get-site-by-name">Developer Function: Server Script: items.GetSiteByName</a><span>10.04.2024 up</span></li>
<li><a href="/en/manual/server-script-items-get-site-by-title">Developer Function: Server Script: items.GetSiteByTitle</a><span>10.04.2024 up</span></li>
<li><a href="/en/manual/server-script-items-max">Developer Function: Server Script: items.Max</a><span>05.16.2025 up</span></li>
<li><a href="/en/manual/server-script-items-maxdate">Developer Function: Server Script: items.MaxDate</a><span>07.28.2025 up</span></li>
<li><a href="/en/manual/server-script-items-min">Developer Function: Server Script: items.Min</a><span>05.16.2025 up</span></li>
<li><a href="/en/manual/server-script-items-mindate">Developer Function: Server Script: items.MinDate</a><span>07.28.2025 up</span></li>
<li><a href="/en/manual/server-script-items-new-result">Developer Function: Server Script: items.NewResult</a><span>08.14.2024 up</span></li>
<li><a href="/en/manual/server-script-items-sum">Developer Function: Server Script: items.Sum</a><span>05.16.2025 up</span></li>
<li><a href="/en/manual/server-script-items-update">Developer Function: Server Script: items.Update</a><span>10.04.2024 up</span></li>
<li><a href="/en/manual/server-script-items-upsert">Developer Function: Server Script: items.Upsert</a><span>12.27.2024 up</span></li>
<li><a href="/en/manual/server-script-api-model">Developer Function: Server Script: apiModel</a><span>08.14.2024 up</span></li>
<li><a href="/en/manual/server-script-api-model-create">Developer Function: Server Script: apiModel.Create</a><span>10.04.2024 up</span></li>
<li><a href="/en/manual/server-script-api-model-delete">Developer Function: Server Script: apiModel.Delete</a><span>08.14.2024 up</span></li>
<li><a href="/en/manual/server-script-api-model-update">Developer Function: Server Script: apiModel.Update</a><span>08.14.2024 up</span></li>
<li><a href="/en/manual/server-script-users">Developer Function: Server Script: users</a><span>08.14.2024 up</span></li>
<li><a href="/en/manual/server-script-user">Developer Function: Server Script: user</a><span>11.19.2025 up</span></li>
<li><a href="/en/manual/server-script-depts">Developer Function: Server Script: depts</a><span>08.14.2024 up</span></li>
<li><a href="/en/manual/server-script-dept">Developer Function: Server Script: dept</a><span>10.04.2024 up</span></li>
<li><a href="/en/manual/server-script-dept-get-members">Developer Function: Server Script: dept.GetMembers</a><span>08.14.2024 up</span></li>
<li><a href="/en/manual/server-script-groups">Developer Function: Server Script: groups</a><span>08.14.2024 up</span></li>
<li><a href="/en/manual/server-script-group">Developer Function: Server Script: group</a><span>10.04.2024 up</span></li>
<li><a href="/en/manual/server-script-group-get-members">Developer Function: Server Script: group.GetMembers</a><span>08.14.2024 up</span></li>
<li><a href="/en/manual/server-script-group-contains-dept">Developer Function: Server Script: group.ContainsDept</a><span>08.14.2024 up</span></li>
<li><a href="/en/manual/server-script-groups-update">Developer Function: Server Script: groups.Update</a><span>10.04.2024 up</span></li>
<li><a href="/en/manual/server-script-group-member">Developer Function: Server Script: groupMember</a><span>10.04.2024 up</span></li>
<li><a href="/en/manual/server-script-notifications">Developer Function: Server Script: notifications</a><span>08.14.2024 up</span></li>
<li><a href="/en/manual/server-script-notifications-get">Developer Function: Server Script: notifications.Get</a><span>08.14.2024 up</span></li>
<li><a href="/en/manual/server-script-notifications-new">Developer Function: Server Script: notifications.New</a><span>08.14.2024 up</span></li>
<li><a href="/en/manual/server-script-notification">Developer Function: Server Script: notification</a><span>10.04.2024 up</span></li>
<li><a href="/en/manual/server-script-notification-send">Developer Function: Server Script: notification.Send</a><span>08.14.2024 up</span></li>
<li><a href="/en/manual/server-script-hidden">Developer Function: Server Script: hidden</a><span>08.14.2024 up</span></li>
<li><a href="/en/manual/server-script-hidden-add">Developer Function: Server Script: hidden.Add</a><span>10.04.2024 up</span></li>
<li><a href="/en/manual/server-script-http-client">Developer Function: Server Script: httpClient</a><span>10.04.2024 up</span></li>
<li><a href="/en/manual/server-script-http-client-get">Developer Function: Server Script: httpClient.Get</a><span>08.14.2024 up</span></li>
<li><a href="/en/manual/server-script-http-client-post">Developer Function: Server Script: httpClient.Post</a><span>10.04.2024 up</span></li>
<li><a href="/en/manual/server-script-http-client-put">Developer Function: Server Script: httpClient.Put</a><span>10.04.2024 up</span></li>
<li><a href="/en/manual/server-script-http-client-delete">Developer Function: Server Script: httpClient.Delete</a><span>08.14.2024 up</span></li>
<li><a href="/en/manual/server-script-ps-csv-csv2str">Developer Function: Server Script: $ps.CSV.csv2str</a><span>06.26.2025 up</span></li>
<li><a href="/en/manual/server-script-ps-csv-str2csv">Developer Function: Server Script: $ps.CSV.str2csv</a><span>06.26.2025 up</span></li>
<li><a href="/en/manual/server-script-ps-file-create-directory">Developer Function: Server Script: $ps.file.createDirectory</a><span>06.26.2025 up</span></li>
<li><a href="/en/manual/server-script-ps-file-create-section">Developer Function: Server Script: $ps.file.createSection</a><span>06.26.2025 up</span></li>
<li><a href="/en/manual/server-script-ps-file-export">Developer Function: Server Script: $ps.file.export</a><span>06.26.2025 up</span></li>
<li><a href="/en/manual/server-script-ps-file-get-directory-list">Developer Function: Server Script: $ps.file.getDirectoryList</a><span>06.26.2025 up</span></li>
<li><a href="/en/manual/server-script-ps-file-get-file-list">Developer Function: Server Script: $ps.file.getFileList</a><span>06.26.2025 up</span></li>
<li><a href="/en/manual/server-script-ps-file-import">Developer Function: Server Script: $ps.file.import</a><span>06.26.2025 up</span></li>
<li><a href="/en/manual/server-script-ps-file-move-directory">Developer Function: Server Script: $ps.file.moveDirectory</a><span>06.26.2025 up</span></li>
<li><a href="/en/manual/server-script-ps-file-move-file">Developer Function: Server Script: $ps.file.moveFile</a><span>06.26.2025 up</span></li>
<li><a href="/en/manual/server-script-ps-file-read-all-text">Developer Function: Server Script: $ps.file.readAllText</a><span>06.26.2025 up</span></li>
<li><a href="/en/manual/server-script-ps-file-remove-directory">Developer Function: Server Script: $ps.file.removeDirectory</a><span>06.26.2025 up</span></li>
<li><a href="/en/manual/server-script-ps-file-remove-file">Developer Function: Server Script: $ps.file.removeFile</a><span>06.26.2025 up</span></li>
<li><a href="/en/manual/server-script-ps-file-remove-section">Developer Function: Server Script: $ps.file.removeSection</a><span>06.26.2025 up</span></li>
<li><a href="/en/manual/server-script-ps-file-write-all-text">Developer Function: Server Script: $ps.file.writeAllText</a><span>06.26.2025 up</span></li>
<li><a href="/en/manual/server-script-ps-json-parse">Developer Function: Server Script: $ps.JSON.parse</a><span>06.26.2025 up</span></li>
<li><a href="/en/manual/server-script-ps-json-stringify">Developer Function: Server Script: $ps.JSON.stringify</a><span>06.26.2025 up</span></li>
<li><a href="/en/manual/server-script-responses-reload">Developer Function: Server Script: responses.Reload</a><span>08.14.2024 up</span></li>
<li><a href="/en/manual/server-script-items-new">Developer Function: Server Scripts: items.New (deprecated)</a><span>03.04.2025 up</span></li></ul></article></div><input id="SearchTextHidden" type="hidden" value="" />