I want to concat 2 values for the call name. I can't use calculated fields or logic hooks because that doesn't work in multiple languages - it would only save one language to the DB.
Instead I need to overwrite the name vardef with
'name' => 'name',
'vname' => 'LBL_SUBJECT',
'dbType' => 'varchar',
'type' => 'name',
'len' => '255',
'source' => 'non-db',
'comment' => 'Brief description of the call',
'importable' => 'required',
But it doesn't return any rows, I can see in the SQL query that it is appending the calls table to the fields
LTRIM(RTRIM(ISNULL(calls.call_topic_c,'')+N' '+ISNULL(calls.subtopic_c,''))) name
but they are in calls_cstm so the query is failing. How can I make the concat use fields in the custom table?
LTRIM(RTRIM(ISNULL(calls_cstm.call_topic_c,'')+N' '+ISNULL(calls_cstm.subtopic_c,''))) name
Using Sugar Ent 7.8