Search DSSTox by pattern — dss_search • ComptoxR

SQL ILIKE pattern search against the values column. Supports % wildcards for partial matching and optional column filtering.

Usage

dss_search(pattern, cols = NULL, limit = 100L, con = NULL)

Arguments

pattern: A string with SQL ILIKE wildcards. Case-insensitive.
cols: Optional character vector of parent_col values to search within. Validated against an internal allowlist. NULL searches all columns.
limit: Maximum number of rows to return. Default 100.
con: An optional DBI::DBIConnection.

Value

A tibble of matching rows with DTXSID, parent_col, values.

See also

Other dsstox: dss_cas(), dss_connect(), dss_diag_freshness(), dss_disconnect(), dss_fuzzy(), dss_install(), dss_query(), dss_resolve(), dss_synonyms()

Examples

if (FALSE) { # \dontrun{
dss_search("Benz%")
dss_search("%chloro%", cols = "PREFERRED_NAME")
dss_search("50-%", cols = "CASRN", limit = 10)
} # }