AnsweredAssumed Answered

Problem with SOAP  - get_entry_list() request.

Question asked by vatrom vatrom on May 11, 2015
Latest reply on May 12, 2015 by vatrom vatrom
Problem with SOAP  - get_entry_list() request. I am trying to make a request on custom module (with SOAP API) and with this parameter (below) ,  I got a strange MySQL error in sugarcrm.log  file
//get list of records ----------------------------------    $get_entry_list_parameters = array(
         'session' => $session_id,
         'module_name' => 'dpinv_Invoices',
         'query' => "",
         'order_by' => "",
         'offset' => '0',
         'select_fields' => array(
         'link_name_to_fields_array' => array(
   'max_results' => '2',
         'deleted' => '0',
         'Favorites' => false,
ERROR FROM sugarcrm.og FILE ----------------------------------
Mon May 11 05:05:54 2015 [18557][1][FATAL] Error running count query for dpinv_Invoices List:  Query Failed:  SELECT count(*) c FROM dpinv_invoices  LEFT JOIN dpinv_invoices_cstm ON = dpinv_invoices_cstm.id_c   LEFT JOIN  users jt0 ON AND jt0.deleted=0
 AND jt0.deleted=0  LEFT JOIN  users jt1 ON AND jt1.deleted=0
 AND jt1.deleted=0  LEFT JOIN  users jt2 ON AND jt2.deleted=0
 AND jt2.deleted=0 LEFT JOIN accounts jt3 ON dpinv_invoices.account_id_c = AND jt3.deleted=0  LEFT JOIN documents jt4 ON dpinv_invoices.document_id_c = AND jt4.deleted=0  LEFT JOIN accounts jt6 ON dpinv_invoices_cstm.account_id1_c = AND jt6.deleted=0  where dpinv_invoices.deleted=0: MySQL error 1054: Unknown column 'dpinv_invoices_cstm.account_id1_c' in 'on clause'
Of course that dpinv_invoices_cstm.account_id1_c does not exist because that field is in the main table not the custom table. 
Relation with account module was made trough module builder.