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 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
(boolean) (defaults to"false"
) (optional)- return the query for counting the solutions
- -page_size
(defaults to"20"
) (optional)- -page_number
(optional)- Returns:
- SQL query
- Partial Call Graph (max 5 caller/called nodes):
- Testcases:
- No testcase defined.