Activity Details report: Sorting by the “Source Email” field: DB Error: no such field.
Steps to replicate:
- Click "Reports" > "Contact Reports"
- Open the "Activity Details" report
- Open the "Sorting" tab
- Set following sorting options :
- Column: Source Email
- Order: Ascending
- Section Header / Group By: check box selected
- Click "Refresh Results"
Actual result: DB Error: no such field.
Expected result: The user can group the “Activity Details” report by the “Source Email” field
Query:
Jul 02 11:00:54 [info] $Fatal Error Details = Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)
[code] => -19
[message] => DB Error: no such field
[mode] => 16
[debug_info] => SELECT ifnull(civicrm_email_source_contact_email, '') as civicrm_email_source_contact_email, ifnull(civicrm_contact_contact_assignee, '') as civicrm_contact_contact_assignee, ifnull(civicrm_contact_contact_target, '') as civicrm_contact_contact_target, ifnull(civicrm_contact_contact_source_id, '') as civicrm_contact_contact_source_id, ifnull(civicrm_contact_contact_assignee_id, '') as civicrm_contact_contact_assignee_id, ifnull(civicrm_contact_contact_target_id, '') as civicrm_contact_contact_target_id, ifnull(civicrm_activity_id, '') as civicrm_activity_id, ifnull(civicrm_activity_source_record_id, '') as civicrm_activity_source_record_id, ifnull(civicrm_activity_activity_type_id, '') as civicrm_activity_activity_type_id, ifnull(civicrm_activity_activity_subject, '') as civicrm_activity_activity_subject, ifnull(civicrm_activity_activity_date_time, '') as civicrm_activity_activity_date_time, ifnull(civicrm_activity_status_id, '') as civicrm_activity_status_id , count(DISTINCT civicrm_activity_id) as ct from civicrm_tmp_e_dflt_8ce364900bed80d360a3cf2827858c9a group by civicrm_email_source_contact_email [nativecode=1054 ** Unknown column 'civicrm_email_source_contact_email' in 'field list']
[type] => DB_Error
[user_info] => SELECT ifnull(civicrm_email_source_contact_email, '') as civicrm_email_source_contact_email, ifnull(civicrm_contact_contact_assignee, '') as civicrm_contact_contact_assignee, ifnull(civicrm_contact_contact_target, '') as civicrm_contact_contact_target, ifnull(civicrm_contact_contact_source_id, '') as civicrm_contact_contact_source_id, ifnull(civicrm_contact_contact_assignee_id, '') as civicrm_contact_contact_assignee_id, ifnull(civicrm_contact_contact_target_id, '') as civicrm_contact_contact_target_id, ifnull(civicrm_activity_id, '') as civicrm_activity_id, ifnull(civicrm_activity_source_record_id, '') as civicrm_activity_source_record_id, ifnull(civicrm_activity_activity_type_id, '') as civicrm_activity_activity_type_id, ifnull(civicrm_activity_activity_subject, '') as civicrm_activity_activity_subject, ifnull(civicrm_activity_activity_date_time, '') as civicrm_activity_activity_date_time, ifnull(civicrm_activity_status_id, '') as civicrm_activity_status_id , count(DISTINCT civicrm_activity_id) as ct from civicrm_tmp_e_dflt_8ce364900bed80d360a3cf2827858c9a group by civicrm_email_source_contact_email [nativecode=1054 ** Unknown column 'civicrm_email_source_contact_email' in 'field list']
[to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT ifnull(civicrm_email_source_contact_email, '') as civicrm_email_source_contact_email, ifnull(civicrm_contact_contact_assignee, '') as civicrm_contact_contact_assignee, ifnull(civicrm_contact_contact_target, '') as civicrm_contact_contact_target, ifnull(civicrm_contact_contact_source_id, '') as civicrm_contact_contact_source_id, ifnull(civicrm_contact_contact_assignee_id, '') as civicrm_contact_contact_assignee_id, ifnull(civicrm_contact_contact_target_id, '') as civicrm_contact_contact_target_id, ifnull(civicrm_activity_id, '') as civicrm_activity_id, ifnull(civicrm_activity_source_record_id, '') as civicrm_activity_source_record_id, ifnull(civicrm_activity_activity_type_id, '') as civicrm_activity_activity_type_id, ifnull(civicrm_activity_activity_subject, '') as civicrm_activity_activity_subject, ifnull(civicrm_activity_activity_date_time, '') as civicrm_activity_activity_date_time, ifnull(civicrm_activity_status_id, '') as civicrm_activity_status_id , count(DISTINCT civicrm_activity_id) as ct from civicrm_tmp_e_dflt_8ce364900bed80d360a3cf2827858c9a group by civicrm_email_source_contact_email [nativecode=1054 ** Unknown column 'civicrm_email_source_contact_email' in 'field list']"]
)