View source for ROLLBACK TIMELINE

==Purpose==
Rolls back transactions stored in the database timeline


==Syntax==
ROLLBACK TIMELINE [RANGE <expC1> [, <expC2>]] [FOR <expL>]


==See Also==
[[CLEAR TIMELINE]], [[DTOS()]], [[DISPLAY TIMELINE]], [[LIST TIMELINE]], [[SET TIMELINE]], [[SET TIMESTAMP]], [[SYSTIMELINE]], [[UNWATCH()]], [[WATCH()]], [[WATCHCHANGED()]], [[WATCHING()]], [[WATCHRESET()]]


==Description==
ROLLBACK TIMELINE rolls back transactions stored in the database timeline.  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 rollback 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 rollback.  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==
<code lang="recital">
rollback timeline range dtos(date()-10), dtos(date()) for systimeline.table = "example"
</code>


==Products==
Recital, Recital Server

[[Category:Documentation]]
[[Category:Commands]]
[[Category:Database Timelines]]