Difference between revisions of "LIST TIMELINE"

Revision as of 10:40, 6 November 2017

Purpose

Lists database timeline transaction information

Syntax

LIST TIMELINE

[RANGE <expC1> [, <expC2>]] | [SINCE <expC1>]

[FOR <expL>]

[TO FILE <.txt filename>]

See Also

CLEAR TIMELINE, DISPLAY TIMELINE, DTOS(), ROLLBACK TIMELINE, SET SYSTIMELINE, SET TIMELINE, SET TIMESTAMP, SYSTIMELINE, TIME(), TIMELINE()

Description

LIST TIMELINE lists database timeline transaction information. Database timelines provide row versioning for Lianja database applications. Whenever a change is made to a table that is timeline enabled, delta changes are automatically recorded for each transaction.

The optional RANGE <expC1> [, <expC2>] and SINCE <expC3> clauses allow the list to be restricted to transactions from a particular date <expC1> or transactions that fall between two inclusive dates: <expC1> and <expC2>. The dates must be specified as strings in the format YYYYMMDDHH:MM:SS (including the time) or YYYYMMDD (date only). The DTOS() function can be used to convert date data type values to YYYYMMDD format. HH:MM:SS is the standard time format returned by the TIME() function.

The optional FOR <expL> clause, where <expL> is a valid logical expression, can also be used to restrict the output. For a structure listing of the database timeline storage table, please see SYSTIMELINE.

The output can be sent to a text file rather than the screen using the optional TO FILE <.txt filename> clause.

Transactions are listed grouped by transaction date and include the following:

• Time of transaction
• Table name
• Row number
• Changed by user@hostname
• Command
• Field old and new values

To enable database timelines issue the SET TIMELINE ON command. SET TIMELINE is OFF by default.

Example

list timeline range dtos(date()-10), dtos(date()) for table = "example"