Documentation:OCLOperators sqlpassthroughobjects: Difference between revisions

OCLOperators sqlpassthroughobjects

Revision as of 07:18, 6 March 2023

This page was created by Lars.olofsson@mdriven.net on 2018-04-02. Last edited by Stephanie@mdriven.net on 2025-01-23.

The two examples below can be used in a derived association.

Kundfaktura.sqlpassthroughobjects('select ' + self.FakturaReferensnummer.toString )->first

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).

@@ Line 1: / Line 1: @@
 ===Example of using 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 to like this=====
+=====If you already have the primary key available, you can do this:=====
   Kundfaktura.sqlpassthroughobjects('select ' + self.FakturaReferensnummer.toString )->first
-=====If 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
- [[Category:OCLOperators]]
+  [[Category:OCLOperators]]
-Notes
+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 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]]).