Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Major
    • Resolution: Fixed/Completed
    • Affects Version/s: 2.1
    • Fix Version/s: 2.2.0
    • Component/s: CiviCRM API
    • Labels:
      None

      Description

      Basically, the Contribution Search API call creates a query that gets all contacts and LEFT JOIN's the contribution and other data. Then, when it is returning the data, it only returns rows that have contribution_id's.

      (1) This is very inefficient. It should pull contributions and then join contact and other data to it.
      (2) This means that trying to limit the number of rows retrieved is not accurate because its counting contact rows.
      (3) The rowCount parameter in the API call is not affecting the actual query. I have not looked into exactly why this is happening.

        Attachments

          Activity

            People

            • Assignee:
              amit Amiteshwar Prasad
              Reporter:
              alan@chicagotech.org Alan Palazzolo
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: