Get all availaible column names from a table in the data warehouse

lims_table_fields(con, table_name, export_type = "character")

Arguments

con: connection to the lims Dwh. Typically by lims_connect()
table_name: name of the table from which the fields are wanted. Important tables are dimSample and factResult.
export_type: how to return: "character", "tibble" or "data.frame"

Value

character vector with column names of the table

Examples

library(inbolims)
con <- lims_connect()
#> Error in pkgdown::build_site_github_pages(new_process = FALSE, install = FALSE): ! ODBC failed with error 00000 from [unixODBC][Driver Manager].
#> ✖ Can't open lib 'SQL Server' : file not found
#> ℹ From nanodbc/nanodbc.cpp:1150.
lims_table_fields(con, "dimSample")
#> Error in h(simpleError(msg, call)): error in evaluating the argument 'conn' in selecting a method for function 'dbGetQuery': object 'con' not found