Skip to content
GitLab
  • Explore
  • Sign in
  • Extensions
  • dataprocessor
  • Issues
  • #102

With CiviCRM Case, adding Case as source, the default values cause an Error

When you have Contact and then Case as data sources, use default values, join "Client :: Contact ID" with "Contact :: Contact ID". Create fields Contact ID, Case ID, Case Type ID, create output, Contact type. Execute it.

It fails on the is_deleted field. I think "_case.is_deleted" in the ON case should be "case.is_deleted".

(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => exceptionHandler
        )

    [code] => -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => SELECT COUNT(*) AS count FROM (SELECT DISTINCT `contact`.`id` AS `contact_id`, `case`.`id` AS `case_id`, `case`.`case_type_id` AS `case_type_id` FROM `civicrm_contact` `contact` INNER JOIN (SELECT `_case`.`id` AS `id`, `_case`.`case_type_id` AS `case_type_id`, `_case`.`subject` AS `subject`, `_case`.`start_date` AS `start_date`, `_case`.`end_date` AS `end_date`, `_case`.`details` AS `details`, `_case`.`status_id` AS `status_id`, `_case`.`is_deleted` AS `is_deleted`, `_case`.`created_date` AS `created_date`, `_case`.`modified_date` AS `modified_date`, `_case_contact`.`case_id` AS `case_contact_case_id`, `_case_contact`.`contact_id` AS `case_contact_contact_id` FROM `civicrm_case` `_case` INNER JOIN `civicrm_case_contact` `_case_contact` ON `_case`.`id`  = `_case_contact`.`case_id`  WHERE 1 AND `_case`.`is_deleted` = 0 ) `case` ON `case`.`case_contact_contact_id`  = `contact`.`id`  AND (`_case`.`is_deleted` = 0) WHERE 1 AND `contact`.`is_deleted` = 0  ORDER BY `contact_id` ASC) `count_combined_sql_data_flow` [nativecode=1054 ** Unknown column '_case.is_deleted' in 'on clause']
    [type] => DB_Error
    [user_info] => SELECT COUNT(*) AS count FROM (SELECT DISTINCT `contact`.`id` AS `contact_id`, `case`.`id` AS `case_id`, `case`.`case_type_id` AS `case_type_id` FROM `civicrm_contact` `contact` INNER JOIN (SELECT `_case`.`id` AS `id`, `_case`.`case_type_id` AS `case_type_id`, `_case`.`subject` AS `subject`, `_case`.`start_date` AS `start_date`, `_case`.`end_date` AS `end_date`, `_case`.`details` AS `details`, `_case`.`status_id` AS `status_id`, `_case`.`is_deleted` AS `is_deleted`, `_case`.`created_date` AS `created_date`, `_case`.`modified_date` AS `modified_date`, `_case_contact`.`case_id` AS `case_contact_case_id`, `_case_contact`.`contact_id` AS `case_contact_contact_id` FROM `civicrm_case` `_case` INNER JOIN `civicrm_case_contact` `_case_contact` ON `_case`.`id`  = `_case_contact`.`case_id`  WHERE 1 AND `_case`.`is_deleted` = 0 ) `case` ON `case`.`case_contact_contact_id`  = `contact`.`id`  AND (`_case`.`is_deleted` = 0) WHERE 1 AND `contact`.`is_deleted` = 0  ORDER BY `contact_id` ASC) `count_combined_sql_data_flow` [nativecode=1054 ** Unknown column '_case.is_deleted' in 'on clause']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="SELECT COUNT(*) AS count FROM (SELECT DISTINCT `contact`.`id` AS `contact_id`, `case`.`id` AS `case_id`, `case`.`case_type_id` AS `case_type_id` FROM `civicrm_contact` `contact` INNER JOIN (SELECT `_case`.`id` AS `id`, `_case`.`case_type_id` AS `case_type_id`, `_case`.`subject` AS `subject`, `_case`.`start_date` AS `start_date`, `_case`.`end_date` AS `end_date`, `_case`.`details` AS `details`, `_case`.`status_id` AS `status_id`, `_case`.`is_deleted` AS `is_deleted`, `_case`.`created_date` AS `created_date`, `_case`.`modified_date` AS `modified_date`, `_case_contact`.`case_id` AS `case_contact_case_id`, `_case_contact`.`contact_id` AS `case_contact_contact_id` FROM `civicrm_case` `_case` INNER JOIN `civicrm_case_contact` `_case_contact` ON `_case`.`id`  = `_case_contact`.`case_id`  WHERE 1 AND `_case`.`is_deleted` = 0 ) `case` ON `case`.`case_contact_contact_id`  = `contact`.`id`  AND (`_case`.`is_deleted` = 0) WHERE 1 AND `contact`.`is_deleted` = 0  ORDER BY `contact_id` ASC) `count_combined_sql_data_flow` [nativecode=1054 ** Unknown column '_case.is_deleted' in 'on clause']"]
)
Assignee
Assign to
Time tracking