Answers.Body: <p>SearchKit is your friend!  It can do 'or' in the search.</p>
  <p>See <a href="https://dmaster.demo.civicrm.org/civicrm/admin/search#/create/Contribution?params=%7B%22version%22:4,%22select%22:%5B%22id%22%5D,%22orderBy%22:%7B%7D,%22where%22:%5B%5B%22OR%22,%5B%5B%22source%22,%22%3D%22,%22thing1%22%5D,%5B%22Contribution_Note_entity_id_01.note%22,%22%3D%22,%22thing2%22%5D%5D%5D%5D,%22groupBy%22:%5B%5D,%22join%22:%5B%5B%22Note%20AS%20Contribution_Note_entity_id_01%22,%22LEFT%22,%5B%22id%22,%22%3D%22,%22Contribution_Note_entity_id_01.entity_id%22%5D,%5B%22Contribution_Note_entity_id_01.entity_table%22,%22%3D%22,%22%27civicrm_contribution%27%22%5D%5D%5D,%22having%22:%5B%5D%7D" rel="nofollow noreferrer">this</a> :</p>
  <p><a href="https://i.sstatic.net/xg0DW.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/xg0DW.png" alt="enter image description here" /></a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-04-14T07:42:51.770Z
Answers.Text: Looks promising. Where do I find this SearchKit? 
  
  Is it a core function in newer versions (I currently run 5.37.2), or should it be installed separately?
Answers.UserDisplayName: Aivars
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-04-15T19:42:53.237Z
Answers.Text: Yes, SearchKit is core functionality but is disabled by default so you will need to enable it on the extensions page (Administer > System Settings > Extensions). It is evolving rapidly, so you'll get the best results if you update to the latest version of CiviCRM. Documentation here: https://docs.civicrm.org/user/en/latest/the-user-interface/search-kit/
Answers.UserDisplayName: William Mortada
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-04-16T08:38:04.360Z
Answers.Text: This is a very good tool. Thanks for suggestion.
Answers.UserDisplayName: Aivars
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-04-12T08:09:45.727Z
Answers.LastActivityDate: 2022-04-12T08:09:45.727Z
Answers.UserDisplayName: Aidan
Answers.Body: <p>This may be what you're looking for: <a href="https://civicrm.org/blog/titania/civicrm%E2%80%99s-powerful-custom-reporting-helps-create-targeted-groups-for-year-end" rel="nofollow noreferrer">https://civicrm.org/blog/titania/civicrm%E2%80%99s-powerful-custom-reporting-helps-create-targeted-groups-for-year-end</a></p>
  <p>You can create two separate groups for each type. Then, include both on the include / exclude custom search page. <strong>Search -&gt; Custom Search -&gt; Include / Exclude</strong></p>
  <p><a href="https://i.sstatic.net/ACx4O.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/ACx4O.png" alt="include exclude search" /></a></p>
  <p>You can create include / exclude searches and save the results as a &quot;super smart group&quot;.</p>
  <p><strong>EDIT:</strong></p>
  <p>You can alternatively use the &quot;Advanced Search&quot; feature to display results as <em><strong>contributions</strong></em>, and use the <em><strong>contributions</strong></em> table to specify specific contribution record criteria (Including Source).</p>
  <p>Don't forget to select <strong>&quot;OR&quot;</strong> as your search operator.</p>
  <p>You can then select all contibution records and export them, selecting the fields you want to export.
  <a href="https://i.sstatic.net/NvvWb.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/NvvWb.png" alt="advanced search" /></a></p>
  <p><a href="https://i.sstatic.net/D5s6e.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/D5s6e.png" alt="Contribution export" /></a></p>
  <p>This may not have every single thing you need, but you can always find other criteria to help narrow down your search. And maybe get you a bit closer?</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-04-14T07:44:44.607Z
Answers.Text: Thanks. However, this would return a group of CONTACTS while I need to get CONTRIBUTIONS. (Not even all contributions of specific contacts, but specific contributions.)
Answers.UserDisplayName: Aivars
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-04-11T19:28:58.603Z
Answers.LastActivityDate: 2022-04-14T16:07:13.213Z
Answers.LastEditDate: 2022-04-14T16:07:13.213Z
Answers.UserDisplayName: Greyson
Answers.Body: <p>You can find both sets of Contacts via SearchBuilder (which is not visible in menu on recent versions but can still be accessed via /civicrm/contact/search/builder?reset=1</p>
  <p><a href="https://i.sstatic.net/e7Egq.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/e7Egq.png" alt="enter image description here" /></a></p>
  <p>Not sure if that gets you close enough to what you need</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-04-14T07:41:39.807Z
Answers.Text: Thanks. However, this search returns CONTACTS while I need to get CONTRIBUTIONS.
  (Also unexpected error while searching with wildcard in Contribution Note, will create a separate issue.)
Answers.UserDisplayName: Aivars
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-04-14T21:17:21.090Z
Answers.Text: then Greyson's answer is better
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-04-11T19:02:16.503Z
Answers.LastActivityDate: 2022-04-11T19:02:16.503Z
Answers.UserDisplayName: petednz - fuzion
Body: <p><a href="https://i.sstatic.net/gAVZb.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/gAVZb.png" alt="Contribution report configuration" /></a></p>
  <p>I have Contacts with 2 types of Contributions.</p>
  <p>A) Contribution with CONTRIBUTION SOURCE = keyword</p>
  <p>B) Contribution with CONTRIBUTION NOTE = keyword</p>
  <p><strong>How can I include both types of CONTRIBUTIONS in a single Report?</strong></p>
  <p>As far as I have checked, I can't search for both, because it is logical AND (I'd need OR for that).</p>
  <p>P.S. Alternatively, I'd like to open CONTRIBUTIONS where SOURCE and NOTE is side by side and I can manually adjust SOURCE until it is uniform (contains keyword).</p>
  
Tags: <civicontribute><civireport><searchkit>
Title: How can I include two types of contribution in a single report
ThreadText: # How can I include two types of contribution in a single report
  
  (Asked by: username_0 on 2022-04-11)
  
  [![Contribution report configuration](https://i.sstatic.net/gAVZb.png)](https://i.sstatic.net/gAVZb.png)
  
  I have Contacts with 2 types of Contributions.
  
  A) Contribution with CONTRIBUTION SOURCE = keyword
  
  B) Contribution with CONTRIBUTION NOTE = keyword
  
  **How can I include both types of CONTRIBUTIONS in a single Report?**
  
  As far as I have checked, I can't search for both, because it is logical AND (I'd need OR for that).
  
  P.S. Alternatively, I'd like to open CONTRIBUTIONS where SOURCE and NOTE is side by side and I can manually adjust SOURCE until it is uniform (contains keyword).
  
  **Tags:** civicontribute, civireport, searchkit
  
  
  ---
  
  ## 3 answers
  
  ### Answer by username_1 on 2022-04-12. Score: 3 | Accepted answer
  
  SearchKit is your friend! It can do 'or' in the search.
  
  See [this](https://dmaster.demo.civicrm.org/civicrm/admin/search#/create/Contribution?params=%7B%22version%22:4,%22select%22:%5B%22id%22%5D,%22orderBy%22:%7B%7D,%22where%22:%5B%5B%22OR%22,%5B%5B%22source%22,%22%3D%22,%22thing1%22%5D,%5B%22Contribution_Note_entity_id_01.note%22,%22%3D%22,%22thing2%22%5D%5D%5D%5D,%22groupBy%22:%5B%5D,%22join%22:%5B%5B%22Note%20AS%20Contribution_Note_entity_id_01%22,%22LEFT%22,%5B%22id%22,%22%3D%22,%22Contribution_Note_entity_id_01.entity_id%22%5D,%5B%22Contribution_Note_entity_id_01.entity_table%22,%22%3D%22,%22%27civicrm_contribution%27%22%5D%5D%5D,%22having%22:%5B%5D%7D) :
  
  [![enter image description here](https://i.sstatic.net/xg0DW.png)](https://i.sstatic.net/xg0DW.png)
  
  > **Comments:**
  > **username_0**: Looks promising. Where do I find this SearchKit?   Is it a core function in newer versions (I currently run 5.37.2), or should it be installed separately?  
  > **username_2**: Yes, SearchKit is core functionality but is disabled by default so you will need to enable it on the extensions page (Administer > System Settings > Extensions). It is evolving rapidly, so you'll get the best results if you update to the latest version of CiviCRM. Documentation here: https://docs.civicrm.org/user/en/latest/the-user-interface/search-kit/  
  > **username_0**: This is a very good tool. Thanks for suggestion.  
  
  ---
  
  ### Answer by username_3 on 2022-04-11. Score: 1
  
  This may be what you're looking for: <https://civicrm.org/blog/titania/civicrm%E2%80%99s-powerful-custom-reporting-helps-create-targeted-groups-for-year-end>
  
  You can create two separate groups for each type. Then, include both on the include / exclude custom search page. **Search -> Custom Search -> Include / Exclude**
  
  [![include exclude search](https://i.sstatic.net/ACx4O.png)](https://i.sstatic.net/ACx4O.png)
  
  You can create include / exclude searches and save the results as a "super smart group".
  
  **EDIT:**
  
  You can alternatively use the "Advanced Search" feature to display results as ***contributions***, and use the ***contributions*** table to specify specific contribution record criteria (Including Source).
  
  Don't forget to select **"OR"** as your search operator.
  
  You can then select all contibution records and export them, selecting the fields you want to export.
  [![advanced search](https://i.sstatic.net/NvvWb.png)](https://i.sstatic.net/NvvWb.png)
  
  [![Contribution export](https://i.sstatic.net/D5s6e.png)](https://i.sstatic.net/D5s6e.png)
  
  This may not have every single thing you need, but you can always find other criteria to help narrow down your search. And maybe get you a bit closer?
  
  > **Comments:**
  > **username_0**: Thanks. However, this would return a group of CONTACTS while I need to get CONTRIBUTIONS. (Not even all contributions of specific contacts, but specific contributions.)  
  
  ---
  
  ### Answer by username_4 on 2022-04-11. Score: 0
  
  You can find both sets of Contacts via SearchBuilder (which is not visible in menu on recent versions but can still be accessed via /civicrm/contact/search/builder?reset=1
  
  [![enter image description here](https://i.sstatic.net/e7Egq.png)](https://i.sstatic.net/e7Egq.png)
  
  Not sure if that gets you close enough to what you need
  
  > **Comments:**
  > **username_0**: Thanks. However, this search returns CONTACTS while I need to get CONTRIBUTIONS. (Also unexpected error while searching with wildcard in Contribution Note, will create a separate issue.)  
  > **username_4**: then username_3's answer is better  
  
  ---
  
  