php - SugarCRM Get Last Email Date and Search on it -

-


php - SugarCRM Get Last Email Date and Search on it -

so have been working sugarcrm pretty extensively lately , need able display lastly date contact emailed search based on how long ago contact emailed.

i can create logic hook lastly email date cannot search based on value of that.

so looked in searchfields.php , found next code gets email of contact.

'email' => array ( 'query_type' => 'default', 'operator' => 'subquery', 'subquery' => 'select eabr.bean_id email_addr_bean_rel eabr bring together email_addresses ea on (ea.id = eabr.email_address_id) eabr.deleted=0 , ea.email_address like', 'db_field' => array ( 0 => 'id', ), ),

using info decided create new array next code lastly email date. need sorted or actual lastly email date if contact emailed multiple times point.

'last_email_c' => array ( 'query_type' => 'default', 'operator' => 'subquery', 'subquery' => 'select e.date_sent emails e e.parent_type = \'contacts\' , e.parent_id = \'{0}\'', 'db_field' => array ( 0 => 'id', ), ),

my issue is, don't know new subquery, checked in listviewdefs , searchdefs , cannot find reference either of these custom searchfields.

what missing?

try one. when utilize subquery have assume parameter form added end of subquery if search blah@blah.com sugar append subquery 'blah@blah.com%' operator way this

t_email_c' => array ( 'query_type' => 'default', 'operator' => 'subquery', 'subquery' => 'select e.date_sent emails e e.parent_type = \'contacts\' , e.parent_id ', 'db_field' => array ( 0 => 'id', ),

also should selecting id of parent record matched against parent record.

basically in subquery should selecting contact id lastly email date like.

if can't write query way need overwriting list.view actions.

php sugarcrm

Comments

Post a Comment

Popular posts from this blog

How do I check if an insert was successful with MySQLdb in Python? -

-
How do I check if an insert was successful with MySQLdb in Python? - i have code: cursor = conn.cursor() cursor.execute(("insert new_files (videos_id, filename, " "is_processing) values (%s,%s,1)"), (id, filename)) logging.warn("%d", cursor.rowcount) if (cursor.rowcount == 1): logging.info("inserted values %d, %s", id, filename) else: logging.warn("failed insert values %d, %s", id, filename) cursor.close() fun is, cursor.rowcount always one, though updated database create videos_id unique key. is, insert fails because in tests same videos_id going appear (and when check database, nil inserted). whatever reason, rowcount 1 - logging.warn have spits out rowcount of 1. so, question: can utilize rowcount work out if insert went fine? if so, (presumably) doing wrong? otherwise, how check if insert went fine? your code not commit after modifications (your modifications rolled back). should...
Read more

delphi - blogger via idHTTP : error 400 bad request -

-
delphi - blogger via idHTTP : error 400 bad request - i'm trying post blogger using idhttp component, however, i'm getting "http/1.0 400 bad request" error. procedure tform1.button1click(sender: tobject); var request,response,req : tstringlist; auth,blogid : string; begin blogid := '00000000000000000000000'; request := tstringlist.create; response := tstringlist.create; req := tstringlist.create; idhttp1.request.connection := 'keep-alive'; idhttp1.request.contenttype := 'application/x-www-form-urlencoded'; idssliohandlersocket1.ssloptions.method := sslvsslv23; request.clear(); request.values['accounttype'] := 'google'; request.values['email'] := 'xxx@gmail.com'; request.values['passwd'] := 'yyy'; request.values['service'] := 'blogger'; response.text :=idhttp1.post('https://www.google.com/accounts/clientlogin',request); auth := resp...
Read more

postgresql - ERROR: operator is not unique: unknown + unknown -

-
postgresql - ERROR: operator is not unique: unknown + unknown - i have postgis database , have compute new values rows in new column. these values should average of values of several columns. query: insert bdps (da_m) values (avg('da_1'+'da_2'+'da_3'+'da_4'+'da_5'+'da_6'+'da_7')); in query bdps database, da_m new column , da_1 da_7 existing columns have double precision type. da_m created using alter table bdps add together column da_m double precision; i next error: error: operator not unique: unknown + unknown line 2: values (avg('da_1'+'da_2'+'da_3'+'da_4'+'da_5'+'da_6'+'da_7... ^ hint: not take best candidate operator. might need add together explicit type casts. ********** error ********** error: operator not unique: unknown + unknown sql state: 42725 hint: not take best candidate operator. might need add togethe...
Read more