xo::db::Class instproc instance_select_query (public)

 <instance of xo::db::Class[i]> 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.
[ show source ]
Show another procedure: