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

 <instance of xo::db::CrClass[i]> 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 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
(boolean) (defaults to "true") (optional)
return subtypes as well
-with_children
(boolean) (defaults to "false") (optional)
return immediate child objects of all objects as well
-publish_status
(optional)
one of 'live', 'ready', or 'production'
-count
(boolean) (defaults to "false") (optional)
return the query for counting the solutions
-folder_id
(optional)
parent_id
-parent_id
(optional)
-page_size
(defaults to "20") (optional)
-page_number
(optional)
-base_table
(defaults to "cr_revisions") (optional)
typically automatic view, must contain title and revision_id
Returns:
SQL query

Partial Call Graph (max 5 caller/called nodes):
%3 test_xowiki_test_cases xowiki_test_cases (test xowiki) xo::db::CrClass instproc instance_select_query xo::db::CrClass instproc instance_select_query test_xowiki_test_cases->xo::db::CrClass instproc instance_select_query

Testcases:
xowiki_test_cases
[ show source ]
Show another procedure: