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

search builder returns incorrect count

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Minor
    • Resolution: Fixed/Completed
    • Affects Version/s: 1.7
    • Fix Version/s: 1.7
    • Component/s: CiviContribute
    • Labels:
      None

      Description

      database has conributions with a source tag of "mailing". There are a total of 126 as found by a direct select using mysql command line. Using search builder the returned count is only 104 but, the list of items is complete. There are 104 individulas and 22 households in the database. It looks like the households are not being included in the count.

      select count(source) from civicrm_contribution where source = "mailing"

      ;
      ---------------

      count(source)

      ---------------

      126

      ---------------

      With search builder
      select civicontribute
      then contribution source
      use the = operator
      string of ""mailing"

      Count is 104

        Attachments

          Activity

            People

            • Assignee:
              kiran.jagtap Kiran Jagtap
              Reporter:
              lhedrick Larry Hedrick
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: