OCLOperators sqlLike
    (Created page with "In SQL databases you have the Like operator. In Ocl we added this same functionality as sqlLike SqlLike works both in OCL and in OCL-PS SqlLike enables you to match part of...")
     
    No edit summary
    Line 1: Line 1:
    In SQL databases you have the Like operator. In Ocl we added this same functionality as sqlLike
    In SQL databases you have the Like operator. In Ocl we added this same functionality as sqlLike


    SqlLike works both in OCL and in OCL-PS
    SqlLike works both in OCL and in [[OCL-PS]]


    SqlLike enables you to match part of strings like this:
    SqlLike enables you to match part of strings like this:
      Person.allinstances->select(a|a.Identity.sqlLike('%'+vSeekParam+'%'))->orderby(identity)
      Person.allinstances->select(a|a.Identity.sqlLike('%'+vSeekParam+'%'))->orderby(identity)
    Add a % to say that "could be anything here"
    Add a % to say that "could be anything here"

    Revision as of 10:27, 22 July 2018

    This page was created by Hans.karlsen@mdriven.net on 2018-07-22. Last edited by Stephanie@mdriven.net on 2025-02-04.

    In SQL databases you have the Like operator. In Ocl we added this same functionality as sqlLike

    SqlLike works both in OCL and in OCL-PS

    SqlLike enables you to match part of strings like this: 

    Person.allinstances->select(a|a.Identity.sqlLike('%'+vSeekParam+'%'))->orderby(identity)

    Add a % to say that "could be anything here"

    Retrieved from "https://wiki.mdriven.net/index.php?title=Documentation:OCLOperators_sqlLike&oldid=2750"

    © 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