dbQueryHistory: Show history of queries loaded into collection

In ctrdata: Retrieve and Analyze Clinical Trials Data from Public Registers

Show history of queries loaded into collection

Description

Note that a new entry is added to the history of queries when ctrLoadQueryIntoDb retrieves at least 1 clinical trial.

Usage

dbQueryHistory(con, verbose = FALSE)

Arguments

con	A database connection object, created with nodbi. See section '1 - Database connection' in ctrdata.
verbose	If TRUE, prints additional information (default FALSE).

Value

A data frame (or tibble, if tibble is loaded) with columns: 'query-timestamp', 'query-register', 'query-records' (note: this is the number of records loaded when last executing ctrLoadQueryIntoDb, not the total record number) and 'query-term', with one row for each time that ctrLoadQueryIntoDb loaded trial records into this collection.

Examples

dbc <- nodbi::src_sqlite(
  dbname = system.file("extdata", "demo.sqlite", package = "ctrdata"),
  collection = "my_trials",
  flags = RSQLite::SQLITE_RO)

dbQueryHistory(con = dbc)

ctrdata documentation built on Jan. 18, 2026, 9:07 a.m.