xo::db::CrClass instproc instance_select_query (public)
<instance of xo::db::CrClass> instance_select_query \ [ -select_attributes select_attributes ] [ -orderby orderby ] \ [ -where_clause where_clause ] [ -from_clause from_clause ] \ [ -with_subtypes on|off ] [ -with_children on|off ] \ [ -publish_status publish_status ] [ -count on|off ] \ [ -folder_id folder_id ] [ -parent_id parent_id ] \ [ -page_size page_size ] [ -page_number page_number ] \ [ -base_table base_table ]
Defined in /var/www/openacs.org/packages/xotcl-core/tcl/cr-procs.tcl
returns the SQL-query to select the CrItems of the specified object_type
- Switches:
- -select_attributes (optional)
- attributes for the SQL query to be retrieved, in addition to item_id, name, publish_status, object_type, and package_id which are always returned
- -orderby (optional)
- for ordering the solution set
- -where_clause (optional)
- clause for restricting the answer set
- -from_clause (optional)
- -with_subtypes (optional, boolean, defaults to
"true"
)- return subtypes as well
- -with_children (optional, boolean, defaults to
"false"
)- return immediate child objects of all objects as well
- -publish_status (optional)
- one of 'live', 'ready', or 'production'
- -count (optional, boolean, defaults to
"false"
)- return the query for counting the solutions
- -folder_id (optional)
- parent_id
- -parent_id (optional)
- -page_size (optional, defaults to
"20"
)- -page_number (optional)
- -base_table (optional, defaults to
"cr_revisions"
)- typically automatic view, must contain title and revision_id
- Returns:
- SQL query
- Testcases:
- xowiki_test_cases