ll_get_device_data_logs: Retrieve data logs

In KopfLab/lablogger: Lab Logger

Retrieve data logs

Description

Returns data logs from the database joined with experiments, devices, and experiment_device_data (for prefix only) tables so filter conditions can be applied on these as well. Sorted by descending order (i.e. latest record first). Note that the group_id filter restricts the selected experiments, device data may theoretically come from devices not (or no longer) associated with the same group although this is rarely the case.

Usage

ll_get_device_data_logs(
  group_id = default(group_id),
  filter = NULL,
  select = c(exp_id, device_id, device_name, device_data_log_id, datetime, data_idx,
    starts_with("data_key"), starts_with("data_")),
  max_rows = NULL,
  convert_to_TZ = Sys.timezone(),
  con = default(con),
  quiet = default(quiet)
)

Arguments

filter	what filter conditions to apply, if any (forwarded to filter)
select	what columns to select (forwarded to select), by default a selection of the most commonly used columns
max_rows	if provided, only selects the indicated number of rows (more efficient this way than part of the filter)
convert_to_TZ	converts the log_datetime to the provided timezone (by default the system's local timezone stored in Sys.timezone()).

Value

device data logs

See Also

Other data logs functions: ll_plot_device_data_logs(), ll_read_device_data_logs_from_file(), ll_write_device_data_logs_to_file()

KopfLab/lablogger documentation built on July 6, 2023, 12:03 a.m.