KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
Tech Tip: Quickly find which tables are not being logged to the journal file
PRODUCT: 4D | VERSION: 16 | PLATFORM: Mac & Win
Published On: January 11, 2018

The following snippet of code can be used to quickly get a list of tables that are not being logged to the Journal file:

C_TEXT($msg;$tableList)
ARRAY TEXT($atTables;0)

// get array of tables not being logged to the journal file
Begin SQL
    SELECT TABLE_NAME
    from _USER_TABLES
    where LOGGED = false
    into :$atTables;
End SQL

// format the array into a comma seperated list
$tableList:=JSON Stringify array($atTables)
$tableList:=Replace string($tableList;Char(Double quote);"")
$tableList:=Replace string($tableList;",";"], [")

// prepare a message and alert the developer
$msg:="The following tables have the \"Include in Log File\" property disabled:\r\r"
$msg:=$msg+$tableList
ALERT($msg)


When executed, an ALERT dialog will be displayed with a list of tables that are not being logged:

See Also: