1E 23.7 (SaaS)

Storage

Core

Set or change the value of the named persistent storage table.

Name (string): The name of the persistent storage table. Case is not significant.

Value (table): The table contents to be written to, or overwritten in, the named persistent storage table.

Append (bool; optional, default false): Whether to append to whatever is already in the table (true) or overwrite it (false).

It is not an error to append if the table does not already exist; in this situation the parameter's value is irrelevent.

MaxRowCount (int; optional, default 1000): When appending, limit the table to this maximum number of rows.

The range is 1 to the SelectRowsLimit configuration value (100000 by default). This can be specified only if Append is true. There is no limit when overwriting (i.e. when Append is explicitly or implicitly false).

Name (string): The name of the new or updated persistent storage table.

A simple example.

@table = Agent.GetSummary();
Storage.Set(Name: "Agent_Summary.Oct2018", Value: @table);

The method overwrites whatever was previously in the table. If you want to accumulate data by appending, these show examples of a task that would be run periodically to record who is logged on at that time. They also return the accumulated data.

Using Append

@loggedOnUsers = Users.GetLoggedOnUsers();
@newEntries = SELECT *, datetime("now") AS Timestamp FROM @loggedOnUsers;
@storageName = SELECT "LoggedInAudit" AS Name;

// Store data
Storage.Set(Name:@storageName, Value:@newEntries, Append:true);
Storage.Get(Name:@storageName);