Table Active or Archive Info

Table Active or Archive Info
 1ot = impact.gui.output_toolbox
 2
 3ot.clear()
 4
 5db = impact.active_database
 6tbl = db.settings.tables.item("TEST")
 7
 8if not tbl.isNone():
 9    ot.add("Located table '" + tbl.name + "'")
10
11    if not tbl.active_flag.isNone():
12        if tbl.active_mode == ipDatabaseTableActiveMode.dtamActive:
13            mode = "Active"
14        else:
15            mode = "Archive"
16
17        ot.add("Active Mode: " + str(mode))
18        ot.add("Active Column: " + str(tbl.active_flag.name))
19
20        if not tbl.active_date.isNone():
21            if tbl.active_utc:
22                utc = "UTC"
23            else:
24                utc = "local"
25
26            ot.add("Active Date: " + tbl.active_date.name + ", " + tbl.active_time.name + " (" + str(utc) + ")")
27
28        if not tbl.active_user.isNone():
29            ot.add("Active User: " + str(tbl.active_user.name))
30
31else:
32    ot.add("Unable to find table 'TEST'")
33
34