Return value

Object DatabaseStatementSelect

Arguments

$field

String field name. Get select statement to referring pages.

$params

Array Statement parameters

Full documentation

Get Select statement for certain page data:

$Invoice = $this->get('page', 'invoice', '1107');
$Statement = $Invoice->newSelectStatement();
$Statement->addSelect('price');

JOIN field

Get Select statement from JOIN field: Invoice rows.

$Invoice = $this->get('page', 'invoice', '1107');
$Statement = $Invoice->newSelectStatement('invoice_rows');

REFERENCE -field

Get Select statement from REFERENCE field: Customer Invoices

$Customer = $this->get('page', 'customer', '1107');
$Statement = $Customer->newSelectStatement('invoice__customer');