Re: concatenation support in entity engine

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

Nope, I'll take a look and see if it solves my problem.  If it does, I'll report
back for the benefit of others. :-)

Thanks,
Leon


David E Jones wrote:

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