SQL Log Active

This attribute feature allows you to check SQL queries executed via Lambda for the purpose of verifying incorrect configuration of BO (Business Object) and Table, or DB constraints during Component Configuration.

If this attribute is checked during execution, information about the executed queries is logged into the qt_sql_comp_log table.

[Image1. Example of data loaded into qt_sql_comp_log table]

How to Use

[Image2. SQL Log Active, which is the property setting of the component.]

1. The default value of the SQL Log Active attribute, which allows logging of Component's logs, is "N/A," which functions the same as "No."
2. Changing SQL Log Active to YES automatically sets logging to begin one hour after the current time. Logging continues until the specified time if changeable.

WARNING

Unlike other properties, SQL Log Active is not provisioned. Therefore, even if configured in the app, it won't apply to Sandbox or Production environments. You can configure and use it as needed in Sandbox environments.