Re: concatenation support in entity engine

Posted by David E Jones-2 on Sep 18, 2006; 10:48am
URL: http://ofbiz.116.s1.nabble.com/concatenation-support-in-entity-engine-tp172516p172517.html


Leon,

Have you tried a view-entity (or DynamicViewEntity) with a complex-
alias?

-David


On Sep 16, 2006, at 12:23 PM, Leon Torres wrote:

> 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