This is what happening please see attached screenshot.
I have managed to add the contact lead source in the search view of meeting.
However, I just can’t search the list by lead source. It always says “No result found”.
I checked the error log, and had this: MySQL error 1054: Unknown column ‘contacts.lead_source’ in ‘where clause’
even after a successful repair and rebuild
It is missing a join clause… please guide me how to resolve this
error log:
Query Failed: SELECT meetings.id ,meetings_cstm.meetingtype_c, meetings.date_start , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod, meetings.parent_id , meetings.parent_type , meetings.date_entered , jt1.user_name created_by_name , jt1.created_by created_by_name_owner , ‘Users’ created_by_name_mod, meetings.assigned_user_id FROM meetings LEFT JOIN meetings_cstm ON meetings.id = meetings_cstm.id_c LEFT JOIN users jt0 ON meetings.assigned_user_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON meetings.created_by=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 where ((contacts.lead_source in (‘Canvassing’))) AND meetings.deleted=0 ORDER BY meetings_cstm.meetingtype_c ASC LIMIT 0,21: MySQL error 1054: Unknown column ‘contacts.lead_source’ in ‘where clause’
Hum,
If i understand, you will research contacts in Meetings ?
For me, it’s hard to resolve this becauses :
Meetings have a “relate field” to many modules … : theses 2 fields are parent_id and parent_type
The contacts subpanel is not a contacts subpanel but come from : meetings_contacts who store : Accept/Decline Status and the id of the contact.