OCLOperators sqlpassthroughobjects
From MDrivenWiki
Example of using the sqlpassthroughobjects
The two examples below can be used in a derived association
If you already have the primary key available you can to like this
Kundfaktura.sqlpassthroughobjects('select ' + self.FakturaReferensnummer.toString )->first
If looking for a specific object using some field
Kundfaktura.sqlpassthroughobjects('select FAKTURA_ID from tbl_FAKTUROR where FAKTURA_ID = ' + self.FakturaReferensnummer.toString )->first
Notes
- You can use @variable in your sql because it is automatically available because it's a variable available when the function is called
- You need to quote strings to be passed (if they aren't variables), like self.Anvandarnamn above. The \' is an escaped quote in OCL (Escape codes)