Answers.Body: <p>Can you also add same filters in api4 as Find Contribution</p>
  <ol>
  <li>is_template = 0</li>
  <li>contribution_status_id = Completed</li>
  </ol>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-08-30T21:06:17.040Z
Answers.Text: right, contribution status is the key, thanks!
Answers.UserDisplayName: yurg
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-08-30T10:31:35.833Z
Answers.LastActivityDate: 2022-08-30T10:31:35.833Z
Answers.UserDisplayName: Pradeep Nayak
Body: <p>Api call below returns <strong>1078</strong> contributions</p>
  <pre><code>$contributions = civicrm_api4('Contribution', 'get', [
    'select' =&gt; [
  'row_count',
      ],
   'where' =&gt; [
  ['contribution_recur_id', 'IS NOT NULL'], 
  ['is_test', '=', FALSE],
  ['contribution_recur_id.start_date', '&gt;=', '2016-01-01'],
     ],
    'checkPermissions' =&gt; FALSE,
    ]);
  </code></pre>
  <p>...while Find Contributions search below</p>
  <pre><code>Is a Template Contribution = '0' ...AND...
  Recurring Contribution Start Date - greater than or equal to &quot;January 1st, 2016 12:00 am&quot; ...AND...
  Contribution Status In Completed ...AND...
  All recurring contributions regardless of payments
  </code></pre>
  <p>returns only <strong>629</strong> records.</p>
  <p>Why?</p>
  
Tags: <recurring-contributions><apiv4>
Title: Recurring Contributions count not match: "Find Contributions" vs API4 Contribution::get
ThreadText: # Recurring Contributions count not match: "Find Contributions" vs API4 Contribution::get
  
  (Asked by: username_0 on 2022-08-30)
  
  Api call below returns **1078** contributions
  
  ```
  $contributions = civicrm_api4('Contribution', 'get', [
    'select' => [
  'row_count',
      ],
   'where' => [
  ['contribution_recur_id', 'IS NOT NULL'], 
  ['is_test', '=', FALSE],
  ['contribution_recur_id.start_date', '>=', '2016-01-01'],
     ],
    'checkPermissions' => FALSE,
    ]);
  
  ```
  
  ...while Find Contributions search below
  
  ```
  Is a Template Contribution = '0' ...AND...
  Recurring Contribution Start Date - greater than or equal to "January 1st, 2016 12:00 am" ...AND...
  Contribution Status In Completed ...AND...
  All recurring contributions regardless of payments
  
  ```
  
  returns only **629** records.
  
  Why?
  
  **Tags:** recurring-contributions, apiv4
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2022-08-30. Score: 3 | Accepted answer
  
  Can you also add same filters in api4 as Find Contribution
  
  1. is\_template = 0
  2. contribution\_status\_id = Completed
  
  > **Comments:**
  > **username_0**: right, contribution status is the key, thanks!  
  
  ---
  
  