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

 <instance of xo::db::CrClass> get_instances_from_db \
    [ -select_attributes select_attributes ] \
    [ -from_clause from_clause ] [ -where_clause where_clause ] \
    [ -orderby orderby ] [ -with_subtypes on|off ] \
    [ -folder_id folder_id ] [ -page_size page_size ] \
    [ -page_number page_number ] [ -base_table base_table ] \
    [ -initialize initialize ]

Defined in packages/xotcl-core/tcl/cr-procs.tcl

Returns a set (ordered composite) of the answer tuples of an 'instance_select_query' with the same attributes. The tuples are instances of the class, on which the method was called.

Switches:

-select_attributes (optional)

-from_clause (optional)

-where_clause (optional)

-orderby (optional)

-with_subtypes (optional, boolean, defaults to "true")

-folder_id (optional)

-page_size (optional, defaults to "20")

-page_number (optional)

-base_table (optional, defaults to "cr_revisions")

-initialize (optional, defaults to "true")

Partial Call Graph (max 5 caller/called nodes):

Testcases:

xotcl_core_tutorial_4, create_form_with_form_instance

Source code:

if {![info exists folder_id]} {
  set folder_id ${:folder_id}
}
set s [:instantiate_objects -sql  [:instance_select_query  -select_attributes $select_attributes  -from_clause $from_clause  -where_clause $where_clause  -orderby $orderby  -with_subtypes $with_subtypes  -folder_id $folder_id  -page_size $page_size  -page_number $page_number  -base_table $base_table  ]  -initialize $initialize]
return $s

XQL Not present:

Generic, PostgreSQL, Oracle