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
