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
