AnsweredAssumed Answered

Sugar CE - Export ALL Notes in List page with lead filter not working

Question asked by Offshore Evolution on Dec 16, 2016
Latest reply on Feb 1, 2017 by Offshore Evolution

Hello,

I am using SugarCRM CE version 6.20. 

Go to Notes List page -> filter with lead -> Now select all records -> Export Notes -> giving below error

( parent_Leads_leads.name like 'NoteTEst NoteTEst%')

Fri Dec 16 18:25:11 2016 [8686][1][FATAL] Error exporting Notes: <BR>.SELECT notes.*, contacts.first_name, contacts.last_name, users.user_name as assigned_user_name ,notes_cstm.custom_note_id_c FROM notes LEFT JOIN contacts ON notes.contact_id=contacts.id LEFT JOIN users ON notes.assigned_user_id=users.id LEFT JOIN notes_cstm ON notes.id = notes_cstm.id_c where (notes.parent_type like 'Leads%' ) AND ( parent_Leads_leads.name like 'NoteTEst NoteTEst%') AND notes.deleted=0 AND (contacts.deleted IS NULL OR contacts.deleted=0) ORDER BY notes.name Query Failed: SELECT notes.*, contacts.first_name, contacts.last_name, users.user_name as assigned_user_name ,notes_cstm.custom_note_id_c FROM notes LEFT JOIN contacts ON notes.contact_id=contacts.id LEFT JOIN users ON notes.assigned_user_id=users.id LEFT JOIN notes_cstm ON notes.id = notes_cstm.id_c where (notes.parent_type like 'Leads%' ) AND ( parent_Leads_leads.name like 'NoteTEst NoteTEst%') AND notes.deleted=0 AND (contacts.deleted IS NULL OR contacts.deleted=0) ORDER BY notes.name: MySQL error 1054: Unknown column 'parent_Leads_leads.name' in 'where clause'

 

 

 

 

Thanks

Offshore Evolution Pvt Ltd

Outcomes