Documentation:OCLOperators sqlpassthroughobjects: Difference between revisions

OCLOperators sqlpassthroughobjects

Latest revision as of 05:42, 23 January 2025

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

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===
+<message>Write the content here to display this box</message>
-The two examples below can be used in a derived association
+===Examples of how to use the sqlpassthroughobjects===
-=====If you already have the primary key available to can to like this=====
+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 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]]
+===== 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 ([[Documentation:Escape codes|Escape codes]]).
+[[Category:OCL General Operators]]
+{{Edited|July|12|2025}}