Ablanor SQL

Source: R/getData.R

Get tables from database usig SQL. Notice, only tables when a procedure-date exists!

getBasereg(
  singleRow,
  reshId = NULL,
  userRole,
  fromDate = NULL,
  toDate = NULL,
  ...
)

getPros(
  singleRow,
  reshId = NULL,
  userRole,
  fromDate = NULL,
  toDate = NULL,
  ...
)

getMce(singleRow, reshId = NULL, userRole, fromDate = NULL, toDate = NULL, ...)

getRand12(
  singleRow,
  reshId = NULL,
  userRole,
  fromDate = NULL,
  toDate = NULL,
  ...
)

getFollowupBasis(
  singleRow,
  reshId = NULL,
  userRole,
  fromDate = NULL,
  toDate = NULL,
  ...
)

getFollowupOneYr(
  singleRow,
  reshId = NULL,
  userRole,
  fromDate = NULL,
  toDate = NULL,
  ...
)

getFollowupFiveYr(
  singleRow,
  reshId = NULL,
  userRole,
  fromDate = NULL,
  toDate = NULL,
  ...
)

getGkv(singleRow, reshId = NULL, userRole, fromDate = NULL, toDate = NULL, ...)

getProms(
  singleRow,
  reshId = NULL,
  userRole,
  fromDate = NULL,
  toDate = NULL,
  ...
)

getHendelse(
  singleRow,
  reshId = NULL,
  userRole,
  fromDate = NULL,
  toDate = NULL,
  ...
)

getFriendlycentre(
  singleRow,
  reshId = NULL,
  userRole,
  fromDate = NULL,
  toDate = NULL,
  ...
)

getMcepatientdata(singleRow, reshId = NULL, userRole, fromDate, toDate, ...)

getPatientlist(
  singleRow,
  reshId = NULL,
  userRole,
  fromDate = NULL,
  toDate = NULL,
  ...
)

getBaseregPros(
  singleRow,
  reshId = NULL,
  userRole,
  fromDate = NULL,
  toDate = NULL,
  ...
)

getLatestEntry()

getNameReshId(asNamedList = FALSE, shortNames = FALSE, newNames = FALSE)

getHospitalName(reshId, shortName = FALSE, newNames = FALSE)

Arguments

singleRow

bools. TRUE only one row, for variable names. FALSE all rows.

reshId

Integer organization id. From login settings.

userRole

String dummy/placeholder role. "LC" has access only to local data (defined by reshId), "SC" has access to national data.

fromDate

NULL default is 01-01-1900. If datadump or pivot table, start date of calendar is used.

toDate

NULL default is newest registration in Abalnor. If datadump or pivot table, end date of calendar is used.

...

Optional arguments to be passed to the function.

asNamedList

Logical whether to return a list of named values or not. Default is FALSE in which case a data frame containing name and id is returned.

newNames

boolean. TRUE uses "sykehusnavn" as defined in 'legg_til_sykehusnavn()'. Default value is FALSE, uses "sykehusnavn" from table Friendlycentre.

shortName

boolean. Default value FALSE and "friendlyname" is returned. If TRUE shortname is returned.

Value

Data frame or (when multiple data sets are returned) a list of data frames containing registry data. In case of getNameReshId() data may also be returned as a named list of values (see Details).

Details

getNameReshId() returns a mapping of organization name and id in the form of columns named name and id. Optionally this function can also return a list of named values (ids), e.g. for use in shiny selection lists.