GitLab

Steps to replicate:

1. Click "Reports" > "Contact Reports"
2. Open the "Activity Details" report
3. Open the "Sorting" tab
4. Set following sorting options :

• Column: Source Email
• Order: Ascending
• Section Header / Group By: check box selected

1. 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']"]
)