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(
              'id',
              'name',
              'in_out_invoice',
         ),
   
         '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.id = dpinv_invoices_cstm.id_c   LEFT JOIN  users jt0 ON dpinv_invoices.modified_user_id=jt0.id AND jt0.deleted=0
 AND jt0.deleted=0  LEFT JOIN  users jt1 ON dpinv_invoices.created_by=jt1.id AND jt1.deleted=0
 AND jt1.deleted=0  LEFT JOIN  users jt2 ON dpinv_invoices.assigned_user_id=jt2.id AND jt2.deleted=0
 AND jt2.deleted=0 LEFT JOIN accounts jt3 ON dpinv_invoices.account_id_c = jt3.id AND jt3.deleted=0  LEFT JOIN documents jt4 ON dpinv_invoices.document_id_c = jt4.id AND jt4.deleted=0  LEFT JOIN accounts jt6 ON dpinv_invoices_cstm.account_id1_c = jt6.id 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.

Outcomes