OCLOperators sqlpassthroughobjects
    (Automatically adding template at the end of the page.)
    No edit summary
     
    (4 intermediate revisions by 3 users not shown)
    Line 1: Line 1:
    <message>Write the content here to display this box</message>
    ===Examples of how to use the sqlpassthroughobjects===
    ===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.
    Line 5: Line 6:
    =====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 ([[Documentation:Escape codes|Escape codes]]).
    [[Category:OCL General Operators]]
    [[Category:OCL General Operators]]
    {{Edited|July|12|2024}}
    {{Edited|July|12|2025}}

    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.

    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).
    Retrieved from "https://wiki.mdriven.net/index.php?title=Documentation:OCLOperators_sqlpassthroughobjects&oldid=26081"

    © MDRIVEN . All Rights Reserved

    API Docs
    MDriven World | Portal | Blog | YouTube | StackOverflow | Facebook

    © MDRIVEN . All Rights Reserved

    MDriven Chat

    How would you like to chat today?

    Setting up your conversation…

    This may take a few moments