Hola tengo un problema en el modulo de worflow para el Notas
Caso cuando agrego una nota a una cuenta la tarea falla y en el log muestra lka siguiente informacion
Tue Feb 19 20:00:18 2019 [9804][1][FATAL] Query Failed: SELECT notes.* ,notes_cstm.consecutivo_oferta_c,notes_cstm.estado_c,notes_cstm.note_id_c,notes_cstm.publicacion_c,notes_cstm.servicio_c,notes_cstm.tipo_c,notes_cstm.tipo_oferta_c,notes_cstm.vigencia_c , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod , jt1.user_name modified_by_name , jt1.created_by modified_by_name_owner , ‘Users’ modified_by_name_mod , jt2.user_name created_by_name , jt2.created_by created_by_name_owner , ‘Users’ created_by_name_mod , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,’’),’ ‘,IFNULL(contacts.last_name,’’)))) contact_name , contacts.assigned_user_id contact_name_owner , ‘Contacts’ contact_name_mod, jt4.name remplaza_oferta_c FROM notes LEFT JOIN notes_cstm ON notes.id = notes_cstm.id_c LEFT JOIN users jt0 ON notes.assigned_user_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON notes.modified_user_id=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 LEFT JOIN users jt2 ON notes.created_by=jt2.id AND jt2.deleted=0
AND jt2.deleted=0 LEFT JOIN contacts contacts ON notes.contact_id=contacts.id AND contacts.deleted=0
AND contacts.deleted=0 LEFT JOIN notes jt4 ON notes_cstm.note_id_c = jt4.id AND jt4.deleted=0 where (parent_type = ‘Emails’ AND parent_id = ‘adbecb82-612f-816b-1620-579bbed8faf7’) AND notes.deleted=0: MySQL error 1052: Column ‘parent_type’ in where clause is ambiguous