Documentation:OCLOperators sqlLike: Difference between revisions

OCLOperators sqlLike

Revision as of 22:25, 16 June 2024

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

Write the content here to display this box

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 15:43, 10 February 2024 (view source) Wikiadmin (talk \| contribs) (Automatically adding template at the end of the page.) ← Older edit		Revision as of 22:25, 16 June 2024 (view source) Wikiadmin (talk \| contribs) (Adding message template to the top of the page) Newer edit →
Line 1:		Line 1:
			{{message\|Write the content here to display this box}}
	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.