Return value

Object DatabaseStatementSelect

Arguments

$params

Array Statement parameters

Full documentation

JOIN field

Get Select statement from JOIN field: Invoice rows.

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

Will produce a statement:

SELECT
   invoice_row.*

FROM
   kayttaja_X_invoice_row AS invoice_row
   LEFT JOIN kayttajatyyppi_X_liitos_XXXXX ON ( kayttajatyyppi_1_liitos_XXXXX.lapsi_nr = invoice_row.nr ) 
   LEFT JOIN kayttaja_X_invoice AS invoice ON ( kayttajatyyppi_1_liitos_XXXXX.isa_nr = invoice.nr  ) 

WHERE
   ( invoice_row.poistettu = 0 )
   AND ( invoice.nr = '1107' )

REFERENCE -field

Get Select statement from REFERENCE field: Customer Invoices

$Invoices = $this->get('page', 'customer', '1183')->getField('invoice__customer');
$Statement = $Invoices->newSelectStatement();

Will produce a statement:

SELECT
    invoice.*

FROM
    kayttaja_X_invoice AS invoice
    LEFT JOIN kayttaja_1_customer AS customer ON ( invoice.customer = customer.nr  ) 

WHERE
   ( invoice.poistettu = 0 )
   AND ( invoice.customer = '1183' )