The collection object has a defined set of components that match the multiMiR
database and defined options in get_multimir()
. Conceptually this is
split into two parts, the relatively straightforward SELECT, FROM, and ON
portion of the query and the more complex filtering and sorting operations:
WHERE and ORDER BY. The latter have their own classes, the former are
resolved as strings (or character vectors) in the functions defining handling
of each sql table (sql_
prefix).
1 2 3 4 5 6 7 8 9 10 | as_mmsql_components(.select = NULL, .from = NULL, .on = NULL,
.where_list = NULL, .orderby = NULL, typeattr = NULL)
as_where_list(...)
as_where(.vars, .connect = NULL, .operator, .value = "%s")
is_where(x)
as_orderby(.vars, .order)
|
as_mmsql_components
: A collection of components that make up a
SQL query.
as_where_list
, as_where
, as_orderby
: Individual
components of a SQL query.
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.