Documentation:OCLOperators sqlLike: Difference between revisions

OCLOperators sqlLike

Latest revision as of 07:52, 17 June 2024

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

Revision as of 22:25, 16 June 2024 (view source) Wikiadmin (talk \| contribs) (Adding message template to the top of the page) ← Older edit		Latest revision as of 07:52, 17 June 2024 (view source) Wikiadmin (talk \| contribs) (Replacing message template with parser tag)
Line 1:		Line 1:
	{{message\|Write the content here to display this box}}		<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.		In SQL databases, you have the Like operator. In OCL, we added this same functionality as SqlLike.