OCLOperators sqlLikeCaseInsensitive
No edit summary
No edit summary
Line 1: Line 1:
When you want to match on strings - or part of strings - but ignoring case
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+'%'))
  Person.allinstances->select(a|a.Name.sqlLikeCaseInsensitive('%'+vSeekParam+'%'))
[[File:2018-07-22 11h09 10.png|none|thumb]]
[[File:2018-07-22 11h09 10.png|none|thumb]]

Revision as of 10:33, 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-12.

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+'%'))
2018-07-22 11h09 10.png