Difference between revisions of "DISPLAY TIMELINE"

From Recital Documentation Wiki
Jump to: navigation, search
 
(5 intermediate revisions by one user not shown)
Line 4: Line 4:
  
 
==Syntax==
 
==Syntax==
DISPLAY TIMELINE [RANGE <expC1> [, <expC2>]] [FOR <expL>]
+
DISPLAY TIMELINE [RANGE <expC1> [, <expC2>]] [FOR <expL>] [TO FILE <.txt filename>]
  
  
 
==See Also==
 
==See Also==
[[CLEAR TIMELINE]], [[DTOS()]], [[LIST TIMELINE]], [[ROLLBACK TIMELINE]], [[SET TIMELINE]], [[SET TIMESTAMP]], [[SYSTIMELINE]]
+
[[CLEAR TIMELINE]], [[DTOS()]], [[LIST TIMELINE]], [[ROLLBACK TIMELINE]], [[SET TIMELINE]], [[SET TIMESTAMP]], [[SYSTIMELINE]], [[TIME()]], [[UNWATCH()]], [[WATCH()]], [[WATCHCHANGED()]], [[WATCHING()]], [[WATCHRESET()]]
  
  
Line 16: Line 16:
 
DISPLAY TIMELINE differs from the LIST TIMELINE command in that it pauses every 17 lines until a key is pressed.   
 
DISPLAY TIMELINE differs from the LIST TIMELINE command in that it pauses every 17 lines until a key is pressed.   
  
The optional RANGE <expC1> [, <expC2>] clause allows the display 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 YYYYMMDD.  The [[DTOS()]] function can be used to convert date data type values to this format.
+
The optional RANGE <expC1> [, <expC2>] clause allows the display 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 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 displayed grouped by transaction date and include the following:
 
Transactions are displayed grouped by transaction date and include the following:
Line 43: Line 45:
 
[[Category:Commands]]
 
[[Category:Commands]]
 
[[Category:Database Timelines]]
 
[[Category:Database Timelines]]
[[Category:Database Timelines Commands]]
 

Latest revision as of 09:44, 6 July 2011

Purpose

Displays database timeline transaction information


Syntax

DISPLAY TIMELINE [RANGE <expC1> [, <expC2>]] [FOR <expL>] [TO FILE <.txt filename>]


See Also

CLEAR TIMELINE, DTOS(), LIST TIMELINE, ROLLBACK TIMELINE, SET TIMELINE, SET TIMESTAMP, SYSTIMELINE, TIME(), UNWATCH(), WATCH(), WATCHCHANGED(), WATCHING(), WATCHRESET()


Description

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

DISPLAY TIMELINE differs from the LIST TIMELINE command in that it pauses every 17 lines until a key is pressed.

The optional RANGE <expC1> [, <expC2>] clause allows the display 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 displayed 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 simply issue the SET TIMELINE ON command in your Recital configuration file. SET TIMELINE is OFF by default.


Example

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


Products

Recital, Recital Server