Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-11857

CiviCases can not be found when they have no activities

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: 4.2.7
    • Fix Version/s: 4.3.0
    • Component/s: CiviCase
    • Labels:
      None

      Description

      When a case is created you IMMEDIATELY HAVE TO assign an activity, because otherwise the Case can never be found again. Not in Advanced Search, not in the Cases Dashboard and not in the Cases Tab of the client.

      When I change
      civicrm/CRM/Case/BAO/Query.php
      line 463
      $from .= " INNER JOIN civicrm_case_activity ON civicrm_case_activity.case_id = civicrm_case.id ";
      $from .= " INNER JOIN civicrm_activity case_activity ON ( civicrm_case_activity.activity_id = case_activity.id
      AND case_activity.is_current_revision = 1 )";
      to
      $from .= " $side civicrm_case_activity ON civicrm_case_activity.case_id = civicrm_case.id ";
      $from .= " $side civicrm_activity case_activity ON ( civicrm_case_activity.activity_id = case_activity.id
      AND case_activity.is_current_revision = 1 )";

      All searches seem to work, but I have no overview of other negative effects of this change.

        Attachments

          Activity

            People

            • Assignee:
              dgg David Greenberg
              Reporter:
              catorghans Hans Idink
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: