concatenation support in entity engine

Posted by Leon Torres-2 on Sep 16, 2006; 7:23pm
URL: http://ofbiz.116.s1.nabble.com/concatenation-support-in-entity-engine-tp172516.html

Hi folks,

Is there a way to do concatenation using entity engine?  If not, how hard would
it be to implement?  Maybe I can take a shot at it.

I'm researching the options for doing searches on several string fields and the
only practical way I can solve the problem is to concatenate the fields in a
defined order and do a LIKE match.  This is the only search space that seems to
work for the intended feature:  To allow a search on firstName + lastName so
that if the user types in "Leon Tor", the result set conains "Leon Tor%" and not
"Leon Alpha" or any results where lastName doesn't start with "Tor".

- Leon