xo::db::Class instproc instance_select_query (public)
<instance of xo::db::Class> instance_select_query \ [ -select_attributes select_attributes ] [ -orderby orderby ] \ [ -where_clause where_clause ] [ -from_clause from_clause ] \ [ -count on|off ] [ -page_size page_size ] \ [ -page_number page_number ]
Defined in /var/www/openacs.org/packages/xotcl-core/tcl/05-db-procs.tcl
Returns the SQL-query to select ACS Objects of the object_type of the class.
- Switches:
- -select_attributes (optional)
- attributes for the SQL query to be retrieved. if no attributes are specified, all attributes are retrieved.
- -orderby (optional)
- for ordering the solution set
- -where_clause (optional)
- clause for restricting the answer set
- -from_clause (optional)
- -count (optional, boolean, defaults to
"false"
)- return the query for counting the solutions
- -page_size (optional, defaults to
"20"
)- -page_number (optional)
- Returns:
- SQL query
- Testcases:
- No testcase defined.