Difference between revisions of "LIST TIMELINE"
Yvonne.milne (Talk | contribs) (→See Also) |
|||
| (11 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Lists database timeline transaction information | Lists database timeline transaction information | ||
| − | |||
==Syntax== | ==Syntax== | ||
| − | LIST TIMELINE [RANGE <expC1> [, <expC2>]] [ | + | LIST TIMELINE |
| + | |||
| + | [RANGE <expC1> [, <expC2>]] | [SINCE <expC1>] | ||
| + | [FOR <expL>] | ||
| − | + | [TO FILE <.txt filename>] | |
| − | [ | + | |
| + | ==See Also== | ||
| + | [[ALTER DATABASE]], [[CLEAR TIMELINE]], [[:Category:Database Timelines|Database Timelines Commands and Functions]], [[Database Timelines (Video)]], [[DTOS()]], [[LIST TIMELINE]], [[MetaData Editor]], [[ROLLBACK TIMELINE]], [[SET SYSTIMELINE]], [[SET TIMELINE]], [[SET TIMESTAMP]], [[SYSTIMELINE|Systimeline System Table]], [[TIMELINE()]], [[Timeline Section Attributes]], [[Understanding database timelines in Lianja|Understanding Database Timelines]] | ||
==Description== | ==Description== | ||
| − | LIST TIMELINE lists database timeline transaction information. Database timelines provide row versioning for | + | 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>] clause allows the list to be restricted to transactions from a particular date <expC1> or transactions that fall between two inclusive dates: <expC1> and <expC2>. | + | The optional RANGE <expC1> [, <expC2>] clause allows the list to be restricted to transactions from a particular date <expC1> or transactions that fall between two inclusive dates: <expC1> and <expC2>. |
| + | The optional SINCE <expC3> clause allows the list to be restricted to transactions from a particular date <expC3> up to the present date. | ||
| + | |||
| + | 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 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]]. | ||
| Line 30: | Line 36: | ||
* Field old and new values | * Field old and new values | ||
| − | To enable database timelines | + | To enable database timelines for a database, use the [[ALTER DATABASE]] <database> METADATA "timeline=on" command. |
| − | + | ||
==Example== | ==Example== | ||
| Line 38: | Line 43: | ||
</code> | </code> | ||
| − | |||
| − | |||
| − | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
| + | [[Category:Databases]] | ||
[[Category:Database Timelines]] | [[Category:Database Timelines]] | ||
| + | [[Category:Lianja VFP Extensions]] | ||
| + | [[Category:VFP Command Extensions]] | ||
Latest revision as of 10:32, 26 March 2020
Contents
Purpose
Lists database timeline transaction information
Syntax
LIST TIMELINE
[RANGE <expC1> [, <expC2>]] | [SINCE <expC1>]
[FOR <expL>]
[TO FILE <.txt filename>]
See Also
ALTER DATABASE, CLEAR TIMELINE, Database Timelines Commands and Functions, Database Timelines (Video), DTOS(), LIST TIMELINE, MetaData Editor, ROLLBACK TIMELINE, SET SYSTIMELINE, SET TIMELINE, SET TIMESTAMP, Systimeline System Table, TIMELINE(), Timeline Section Attributes, Understanding Database Timelines
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>] clause allows the list to be restricted to transactions from a particular date <expC1> or transactions that fall between two inclusive dates: <expC1> and <expC2>.
The optional SINCE <expC3> clause allows the list to be restricted to transactions from a particular date <expC3> up to the present date.
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 for a database, use the ALTER DATABASE <database> METADATA "timeline=on" command.
Example
list timeline range dtos(date()-10), dtos(date()) for table = "example"
