AnsweredAssumed Answered

Bean 'name' is being concatenated as f_name, l_name?

Question asked by gperez gperez on Aug 1, 2014
Hi. We are running 6.5.16 CE.

Trying to display A module name in B search list results (as a column) we are running in a problem. The resulting 'name' is being concatenated as first_name + last_name! Why could it be?

The generated Query points the 'name' like this:

LTRIM(RTRIM(CONCAT(IFNULL(jt0.first_name,''),' ',IFNULL(jt0.last_name,'')))) reser_payments_name

Name is being declared in a relationship like:
'rname' => 'name'

And there's nothing in vardefs to make us think this concatenation should exist.

Oh! Btw, this user had the same issue with 6.5 PRO version. No answers anyway:
http://forums.sugarcrm.com/f6/listview-name-field-module-relationship-being-swapped-out-82650/

Any clue?

Outcomes