Documentation:OCLOperators sqlLike: Difference between revisions

OCLOperators sqlLike

Latest revision as of 04:57, 4 February 2025

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

@@ Line 1: / Line 1: @@
+<message>Write the content here to display this box</message>
 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 [[Documentation:OCL-PS|OCL-PS]].
 SqlLike enables you to match part of strings like this:
@@ Line 7: / Line 8: @@
 Add a <code>%</code> to say that "could be anything here."
-See also: [[OCLOperators sqlLikeCaseInsensitive|sqlLikeCaseInsensitive]]
+See also: [[Documentation:OCLOperators sqlLikeCaseInsensitive|sqlLikeCaseInsensitive]]
 [[Category:OCLOperators]]
+{{Edited|July|12|2025}}