ctrdata (version 1.5.2)

dbFindIdsUniqueTrials: Deduplicate records to provide unique clinical trial identifiers

Description

If records for a clinical trial are found from more than one register, the record from EUCTR is returned. The function currently relies on CTGOV recording other identifiers such as the EudraCT number in the field "Other IDs".

Usage

dbFindIdsUniqueTrials(
  preferregister = "EUCTR",
  prefermemberstate = "GB",
  include3rdcountrytrials = TRUE,
  con,
  verbose = TRUE
)

Arguments

preferregister

The abbreviation of the preferred register, in case a trial is in more than one register (string, either "EUCTR" or "CTGOV"). If set to an empty string (""), keeps the keys for the same trial in both registers in the returned vector.

prefermemberstate

Code of single EU Member State for which records should returned. If not available, a record for GB or lacking this, any other record for the trial will be returned. For a list of codes of EU Member States, please see vector countriesEUCTR. Alternatively, "3RD" will lead to return a Third Country record of a trial, if available.

include3rdcountrytrials

A logical value if trials should be retained that are conducted exclusively in third countries, that is, outside the European Union.

con

A src connection object, as obtained with nodbi::src_mongo() or nodbi::src_sqlite()

verbose

If set to TRUE, prints out information about numbers of records found at subsequent steps when searching for duplicates

Value

A vector with strings of keys ("_id" in the database) that represent non-duplicate trials.

Examples

# NOT RUN {
# }
# NOT RUN {
db <- nodbi::src_sqlite(
  collection = "my_collection"
)
dbFindIdsUniqueTrials(
  con = db
)
# }
# NOT RUN {
# }