Skip to main content

Get log

Retrieves connection log data (when in-memory logging is enabled)

Function GetLog(Val Connection, Val AsString = False, Val EventCount = 100) Export

ParameterCLI optionTypeRequiredDescription
Connection-ArbitraryAddIn object with open connection
AsString-BooleanTrue > returns log as a single string, False > as an array
EventCount-NumberNumber of recent events to retrieve. 0 > no limits
Returns

String, Map Of KeyAndValue - Log as a string or a map with the full execution result

Caution

NOCLI: this method is not available in CLI version

1C:Enterprise/OneScript code example
LogFile = GetTempFileName("txt");
LoggingSettings = OPI_PostgreSQL.GetLoggingSettings(True, 100, LogFile);

Address = "127.0.0.1";
Login = "bayselonarrend";
Password = "12we...";
Base = "postgres";

TLS = True;
Port = 5432;
ConnectionString = OPI_PostgreSQL.GenerateConnectionString(Address, Base, Login, Password, Port);

If TLS Then
TLSSettings = OPI_PostgreSQL.GetTLSSettings(True);
Else
TLSSettings = Undefined;
EndIf;

Connection = OPI_PostgreSQL.CreateConnection(ConnectionString, TLSSettings, LoggingSettings);

If Not OPI_PostgreSQL.IsConnector(Connection) Then
Raise OPI_Tools.JSONString(Connection);
EndIf;

Result = OPI_PostgreSQL.ExecuteSQLQuery("SELECT 1 AS n", , , Connection);

Result = OPI_PostgreSQL.GetLog(Connection);
Result
{
"logs": [
"[2026-05-26 13:50:24.460] Connecting to PostgreSQL...",
"[2026-05-26 13:50:24.496] Connected to PostgreSQL"
],
"result": true,
"returned": 2,
"total": 2
}