Eclipse Community Forums: EclipseLink » query-by-example and trim?

Home » Eclipse Projects » EclipseLink » query-by-example and trim?(how to trim for example query?)

query-by-example and trim? [message #641025]

Tue, 23 November 2010 18:18

Eclipse User

I have a db field (varchar) that may or may not contain leading and trailing spaces.
I would like to use query-by-example using this field as part of the object's example criteria but I need some way to tell the example to trim the field. A simple sql query would use: trim(name) = 'bob'

Is there any way to configure the query by example to do this? Maybe using some flavor of QueryByExamplePolicy?

As always, thanks in advance.
Tony

Re: query-by-example and trim? [message #641471 is a reply to message #641025]

Thu, 25 November 2010 10:32

Eclipse User

Query by example is for simple queries. You will need to use JPQL, Criteria, or Expressions.

Previous Topic:	MySQL: update on self-referencing foreign key tables leads to Duplicate Key Exception
Next Topic:	reading new primary key of inserted object

Goto Forum:

-=] Back to Top [=-

Current Time: Sun Jul 20 05:52:23 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter