by Mien Trung Software

MTS SubPanel Search makes it easy to QUICK SEARCH ANY INFORMATION IN A SUBPANEL. Because you can filter searches right from any subpanel you can drill down to the exact record you need in little time. This gets you back to focusing on the real business value task on hand.

Includes a 30 day guarantee
Try it Now

#4079 - Tasks searching is not working

Closed Bug? created by GBlack 2 years ago

Hi I am getting error in tasks searching.

ERROR: Query Failed: ( SELECT count(*) c FROM tasks LEFT JOIN tasks_cstm ON tasks.id = tasks_cstm.id_c INNER JOIN ssi_vessels_tasks_1_c ON tasks.id=ssi_vessels_tasks_1_c.ssi_vessels_tasks_1tasks_idb AND ssi_vessels_tasks_1_c.ssi_vessels_tasks_1ssi_vessels_ida='2dd4dd60-6d11-99bf-fbc5-5f7736b86d85' AND ssi_vessels_tasks_1_c.deleted=0

where ( tasks_cstm.service_status_c NOT IN ('Complete') AND tasks.id IN (SELECT tasks.id FROM tasks LEFT JOIN tasks_cstm ON tasks.id = tasks_cstm.id_c LEFT JOIN ssi_vessels_tasks_1_c jtl0 ON tasks.id=jtl0.ssi_vessels_tasks_1tasks_idb AND jtl0.deleted=0

LEFT JOIN ssi_vessels jt0 ON jt0.id=jtl0.ssi_vessels_tasks_1ssi_vessels_ida AND jt0.deleted=0 AND jt0.deleted=0 LEFT JOIN ssi_vendors_tasks_1_c jtl1 ON tasks.id=jtl1.ssi_vendors_tasks_1tasks_idb AND jtl1.deleted=0

LEFT JOIN ssi_vendors jt1 ON jt1.id=jtl1.ssi_vendors_tasks_1ssi_vendors_ida AND jt1.deleted=0 AND jt1.deleted=0 LEFT JOIN users jt2 ON tasks.assigned_user_id=jt2.id AND jt2.deleted=0

AND jt2.deleted=0 where (((tasks.name like 'salt%' ) OR ( tasks.name like '%salt%' ) OR ( tasks.name like '%salt' ) OR ( ( contacts.first_name like 'salt%' OR contacts.last_name like 'salt%' ) ) OR ( ( contacts.first_name like '%salt%' OR contacts.last_name like '%salt%' ) ) OR ( ( contacts.first_name like '%salt' OR contacts.last_name like '%salt' ) ) OR ( tasks.date_entered LIKE 'salt%' ) OR ( tasks.date_entered LIKE '%salt' ) OR ( tasks.date_modified LIKE 'salt%' ) OR ( tasks.date_modified LIKE '%salt' ) OR ( tasks.modified_user_id LIKE 'salt%' ) OR ( tasks.modified_user_id LIKE '%salt' ) OR ( tasks.created_by LIKE 'salt%' ) OR ( tasks.created_by LIKE '%salt' ) OR ( tasks.description LIKE 'salt%' ) OR ( tasks.description LIKE '%salt' ) OR ( tasks.assigned_user_id LIKE 'salt%' ) OR ( tasks.assigned_user_id LIKE '%salt' ) OR ( tasks.status LIKE 'salt%' ) OR ( tasks.status LIKE '%salt' ) OR ( tasks.date_due LIKE 'salt%' ) OR ( tasks.date_due LIKE '%salt' ) OR ( tasks.date_start LIKE 'salt%' ) OR ( tasks.date_start LIKE '%salt' ) OR ( tasks.parent_type LIKE 'salt%' ) OR ( tasks.parent_type LIKE '%salt' ) OR ( tasks.priority LIKE 'salt%' ) OR ( tasks.priority LIKE '%salt' ) OR ( tasks.rt_list_id LIKE 'salt%' ) OR ( tasks.rt_list_id LIKE '%salt' ) OR ( tasks.calendar_id_c LIKE 'salt%' ) OR ( tasks.calendar_id_c LIKE '%salt' ) OR ( tasks.rt_gtask_id LIKE 'salt%' ) OR ( tasks.rt_gtask_id LIKE '%salt' ) OR ( tasks.rt_gtask_parentid LIKE 'salt%' ) OR ( tasks.rt_gtask_parentid LIKE '%salt' ) OR ( tasks.rt_list_name LIKE 'salt%' ) OR ( tasks.rt_list_name LIKE '%salt' ) OR ( tasks.rt_gevent_id LIKE 'salt%' ) OR ( tasks.rt_gevent_id LIKE '%salt' ) OR ( tasks.rt_calendar_type LIKE 'salt%' ) OR ( tasks.rt_calendar_type LIKE '%salt' ) OR ( tasks_cstm.billing_c LIKE 'salt%' ) OR ( tasks_cstm.billing_c LIKE '%salt' ) OR ( tasks_cstm.service_status_c LIKE 'salt%' ) OR ( tasks_cstm.service_status_c LIKE '%salt' ) OR ( tasks_cstm.owners_comments_c LIKE 'salt%' ) OR ( tasks_cstm.owners_comments_c LIKE '%salt' ) OR ( tasks_cstm.service_notes_c LIKE 'salt%' ) OR ( tasks_cstm.service_notes_c LIKE '%salt' ) OR ( tasks_cstm.service_type_c LIKE 'salt%' ) OR ( tasks_cstm.service_type_c LIKE '%salt' ) OR ( tasks_cstm.type_c LIKE 'salt%' ) OR ( tasks_cstm.type_c LIKE '%salt' ) OR ( tasks_cstm.service_id_number_c LIKE 'salt%' ) OR ( tasks_cstm.service_id_number_c LIKE '%salt'))) AND tasks.deleted=0 ) ) AND tasks.deleted=0 ): MySQL error 1054: Unknown column 'contacts.first_name' in 'where clause'

  1. nhat.thieu member avatar

    Mien Trung Software Provider Affiliate

    2 years ago

    Hello,

    Can you give use your SuiteCRM version?

    Thanks, SuiteCRM Addon Team

    • nhat.thieu member avatar

      Mien Trung Software Provider Affiliate

      2 years ago

      Also, Can you confirm do you link Tasks module with Contacts module?

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
  • "This module added a crucial feature to our SuiteCRM installation, as we have accumulated many records over the years and searching was becoming cumber..." - franklinian

    Read More Reviews