Difference between revisions of "LIST TIMELINE"
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | |||
==Purpose== | ==Purpose== | ||
| − | + | Lists database timeline transaction information | |
| − | + | ||
==Syntax== | ==Syntax== | ||
| − | LIST TIMELINE [RANGE <expC1> [, <expC2>] [FOR <expL>] | + | LIST TIMELINE [RANGE <expC1> [, <expC2>]] [FOR <expL>] |
==See Also== | ==See Also== | ||
| − | [[CLEAR TIMELINE]], [[DTOS()]], [[ROLLBACK TIMELINE]], [[SET TIMELINE]], [[SET TIMESTAMP]], [[SYSTIMELINE]] | + | [[CLEAR TIMELINE]], [[DISPLAY TIMELINE]], [[DTOS()]], [[ROLLBACK TIMELINE]], [[SET TIMELINE]], [[SET TIMESTAMP]], [[SYSTIMELINE]] |
==Description== | ==Description== | ||
| + | LIST TIMELINE lists 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. | ||
| + | |||
| + | 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 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 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]]. |
| − | + | To enable database timelines simply issue the SET TIMELINE ON command in your Recital configuration file. SET TIMELINE is OFF by default. | |
==Example== | ==Example== | ||
<code lang="recital"> | <code lang="recital"> | ||
| − | list timeline | + | list timeline range dtos(date()-10), dtos(date()) for table = "example" |
</code> | </code> | ||
Revision as of 16:43, 30 November 2009
Purpose
Lists database timeline transaction information
Syntax
LIST TIMELINE [RANGE <expC1> [, <expC2>]] [FOR <expL>]
See Also
CLEAR TIMELINE, DISPLAY TIMELINE, DTOS(), ROLLBACK TIMELINE, SET TIMELINE, SET TIMESTAMP, SYSTIMELINE
Description
LIST TIMELINE lists 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.
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 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 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.
To enable database timelines simply issue the SET TIMELINE ON command in your Recital configuration file. SET TIMELINE is OFF by default.
Example
list timeline range dtos(date()-10), dtos(date()) for table = "example"
Products
Recital, Recital Server
