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

Custom search by date added incorrectly joins on email while grouping by contact_id

          Details

          • Type: Bug
          • Status: Done/Fixed
          • Priority: Major
          • Resolution: Fixed/Completed
          • Affects Version/s: 3.2.4
          • Fix Version/s: 3.4.alpha
          • Component/s: CiviCRM Search
          • Labels:
            None

            Description

            Line 350 of CRM/Contact/Form/Search/Custom/DateAdded.php has a join on civicrm_email which it says has something to do with smart groups, but since the whole query is grouped by contact_id this can produce incorrect results.

            Quick fix is probably to remove that line since email isn't used on the results page but I'm not sure what it will affect with smart groups, or why it's there.

              Attachments

                Activity

                  People

                  • Assignee:
                    lobo Donald A. Lobo
                    Reporter:
                    demeritcowboy Dave D
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    0 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: