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 6: / Line 6: @@
 =====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:
+===== 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]]).
+* 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}}