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

Help

Home

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

Show: Today's Messages :: Show Polls :: Message Navigator

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

Tue, 23 November 2010 23:18

tbianchi

Messages: 4
Registered: November 2010

Junior Member

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

Report message to a moderator

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

Thu, 25 November 2010 15:32

James Sutherland

Messages: 1939
Registered: July 2009
Location: Ottawa, Canada

Senior Member

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

James : Wiki : Book : Blog : Twitter

Report message to a moderator

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 [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 09 08:38:15 GMT 2020

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter