OCLOperators sqlpassthroughobjects
No edit summary |
(Automatically adding template at the end of the page.) |
||
| (4 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
=== | ===Examples of how to use the sqlpassthroughobjects=== | ||
The two examples below can be used in a derived association. | The two examples below can be used in a derived association. | ||
=====If you already have the primary key available, you can do this:===== | =====If you already have the primary key available, you can do this:===== | ||
| Line 5: | Line 5: | ||
=====If you are looking for a specific object using some field:===== | =====If you are looking for a specific object using some field:===== | ||
Kundfaktura.sqlpassthroughobjects('select FAKTURA_ID from tbl_FAKTUROR where FAKTURA_ID = ' + self.FakturaReferensnummer.toString )->first | Kundfaktura.sqlpassthroughobjects('select FAKTURA_ID from tbl_FAKTUROR where FAKTURA_ID = ' + self.FakturaReferensnummer.toString )->first | ||
Notes: | Notes: | ||
* You can use '''@variable''' in your SQL because it is an automatically available variable when the function is called. | * You can use '''@variable''' in your SQL because it is an automatically available variable 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]]). | * 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]]). | ||
[[Category:OCL General Operators]] | |||
{{Edited|July|12|2024}} | |||
Latest revision as of 15:43, 10 February 2024
Examples of how to use the sqlpassthroughobjects
The two examples below can be used in a derived association.
If you already have the primary key available, you can do this:
Kundfaktura.sqlpassthroughobjects('select ' + self.FakturaReferensnummer.toString )->first
If you are 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 an automatically available variable 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).
This page was edited 101 days ago on 02/10/2024. What links here