View source for DISPLAY TIMELINE

From Recital Documentation Wiki

← DISPLAY TIMELINE

You do not have permission to edit this page, for the following reason:

---

You can view and copy the source of this page:

{{YLM to do}} date and time ==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]] ==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 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]]. 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== <code lang="recital"> display timeline range dtos(date()-10), dtos(date()) for table = "example" </code> ==Products== Recital, Recital Server [[Category:Documentation]] [[Category:Commands]] [[Category:Database Timelines]] [[Category:Database Timelines Commands]]

Return to DISPLAY TIMELINE.