Application Fields

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:

FieldMeaning
rtd_server_VersionThe DB RTD version
rtd_server_RegistrationInformation about the registered edition and trial period
rtd_server_TimeZoneThe TimeZone setting
rtd_server_DateTimeThe current date and time adjusted to the specified time zone
rtd_server_DateThe current date adjusted to the specified time zone
rtd_server_TimeThe 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 ValueMeaning
1The value is changed up
0The value is unchanged
-1The value is changed down

Row Specific Fields

Use the following fields to get the information about queries at the row level:

FieldMeaning
rtd_LastUpdateThe date and time of the last update
rtd_LastUpdateDateThe date of the last update
rtd_LastUpdateTimeThe time of the last update
rtd_LastErrorThe last error code
rtd_LastMessageThe 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:

FieldMeaning
rtd_RefreshIntervalThe 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)