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.