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.