Documentation:OCLOperators sqlLikeCaseInsensitive: Difference between revisions

OCLOperators sqlLikeCaseInsensitive

Revision as of 10:33, 22 July 2018

When you want to match on strings - or part of strings - but ignoring case

It works just like sqlLike but ignores case (sqlLike might ignore case in ps search - this depends on db settings )

Person.allinstances->select(a|a.Name.sqlLikeCaseInsensitive('%'+vSeekParam+'%'))

This page was edited 96 days ago on 02/10/2024. What links here

@@ Line 1: / Line 1: @@
 When you want to match on strings - or part of strings - but ignoring case
-It works just like [[sqlLike]] but ignores case (sqlLike might ignore case in ps search - this depends on db settings )
+It works just like [[OCLOperators sqlLike|sqlLike]] but ignores case (sqlLike might ignore case in ps search - this depends on db settings )
   Person.allinstances->select(a|a.Name.sqlLikeCaseInsensitive('%'+vSeekParam+'%'))
 [[File:2018-07-22 11h09 10.png|none|thumb]]