Application Fields
Application fields allow getting information about application settings, queries, and value changes using RTD formulas.
Server Fields
Formula format:
=RTD("db.rtd",,"<Data field>")
For example:
=RTD("db.rtd",,"rtd_server_Version")
=RTD("db.rtd",,"rtd_server_Registration")
Complete list of fields:
| Field | Meaning |
|---|---|
| rtd_server_Version | The DB RTD version |
| rtd_server_Registration | Information about the registered edition and trial period |
| rtd_server_TimeZone | The TimeZone setting |
| rtd_server_DateTime | The current date and time adjusted to the specified time zone |
| rtd_server_Date | The current date adjusted to the specified time zone |
| rtd_server_Time | The current time adjusted to the specified time zone |
Immediate Refresh
You can call the following function to start refreshing data immediately:
=RTD("db.rtd",,"rtd_refresh_now")
Tick Fields
Tick fields allow understanding value change directions and can be used with conditional formatting.
Add the :tick suffix to the underlying data field name. For example:
=RTD("db.rtd",,"sqlexpress","dbo.quotes","symbol","AAPL","last")
=RTD("db.rtd",,"sqlexpress","dbo.quotes","symbol","AAPL","last:tick")
Tick values:
| Tick Value | Meaning |
|---|---|
| 1 | The value is changed up |
| 0 | The value is unchanged |
| -1 | The value is changed down |
Row Specific Fields
Use the following fields to get the information about queries at the row level:
| Field | Meaning |
|---|---|
| rtd_LastUpdate | The date and time of the last update |
| rtd_LastUpdateDate | The date of the last update |
| rtd_LastUpdateTime | The time of the last update |
| rtd_LastError | The last error code |
| rtd_LastMessage | The last error message |
For example, if a data formula is
=RTD("db.rtd",,"sqlexpress","dbo.quotes","symbol","AAPL","last")
you can monitor the status like:
=RTD("db.rtd",,"sqlexpress","dbo.quotes","symbol","AAPL","rtd_LastUpdate")
=RTD("db.rtd",,"sqlexpress","dbo.quotes","symbol","AAPL","rtd_LastError")
=RTD("db.rtd",,"sqlexpress","dbo.quotes","symbol","AAPL","rtd_LastMessage")
Table Specific Fields
Use the following fields to get the information at the table level:
| Field | Meaning |
|---|---|
| rtd_RefreshInterval | The refresh interval (get and set) |
For example, if a data formula is
=RTD("db.rtd",,"sqlexpress","dbo.quotes","symbol","AAPL","last")
you can get the table refresh interval like:
=RTD("db.rtd",,"sqlexpress","dbo.quotes","rtd_RefreshInterval")
and set the interval (in seconds) using the formula like this (15 minutes):
=RTD("db.rtd",,"sqlexpress","dbo.quotes","rtd_RefreshInterval",15*60)