dbQueryHistory

Show history of queries loaded into a database collection

A system for querying, retrieving and analyzing
protocol- and results-related information on clinical trials from
four public registers, the 'European Union Clinical Trials Register'
('EUCTR', <https://www.clinicaltrialsregister.eu/>),
'ClinicalTrials.gov' (<https://clinicaltrials.gov/> and also
translating queries the retired classic interface), the
'ISRCTN' (<http://www.isrctn.com/>) and the
'European Union Clinical Trials Information System'
('CTIS', <https://euclinicaltrials.eu/>).
Trial information is downloaded, converted and stored in a database
('PostgreSQL', 'SQLite', 'DuckDB' or 'MongoDB'; via package 'nodbi').
Protocols, statistical analysis plans, informed consent sheets and other
documents in registers associated with trials can also be downloaded.
Other functions implement trial concepts canonically across registers,
identify deduplicated records, easily find and extract variables
(fields) of interest even from complex nested data as used by the
registers, merge variables and update queries.
The package can be used for monitoring, meta- and trend-analysis of
the design and conduct as well as of the results of clinical trials
across registers.

Ralf Herold

ctrdata

Retrieve and Analyze Clinical Trials Data from Public Registers

dbQueryHistory function

<dl><dt>con</dt>
<dd>A database connection object, created with
<code>nodbi</code>. See section `1 - Database connection` in
ctrdata.</dd>
<dt>verbose</dt>
<dd>If <code>TRUE</code>, prints additional information
(default <code>FALSE</code>).</dd></dl>

Arguments

Show history of queries loaded into a database collection — dbQueryHistory

<dl>

<dt>con</dt>
<dd>A database connection object, created with
<code>nodbi</code>. See section `1 - Database connection` in
ctrdata.</dd>


<dt>verbose</dt>
<dd>If <code>TRUE</code>, prints additional information
(default <code>FALSE</code>).</dd>

</dl>

dbQueryHistory: Show history of queries loaded into a database collection

Description

Usage

Value

Arguments

Examples