Answers.Body: <p>I wrote an extension <a href="https://github.com/MegaphoneJon/com.megaphonetech.softcreditcustomfields" rel="nofollow noreferrer">Soft Credit Custom Fields</a> which, amongst other things, adds a "Soft Creditee's Name" field to the Advanced Search.  </p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-06-17T18:19:30.620Z
Answers.LastActivityDate: 2019-06-17T18:19:30.620Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.Body: <p>With SearchKit it's possible to create the smart group without the help of the extension:</p>
  <pre><code>[
    [
      &quot;SavedSearch&quot;,
      &quot;save&quot;,
      {
        &quot;records&quot;: [
          {
            &quot;name&quot;: &quot;Fundraisers_P2P&quot;,
            &quot;label&quot;: &quot;Fundraisers P2P&quot;,
            &quot;api_entity&quot;: &quot;Contact&quot;,
            &quot;api_params&quot;: {
              &quot;version&quot;: 4,
              &quot;select&quot;: [
                &quot;id&quot;,
                &quot;sort_name&quot;,
                &quot;contact_type:label&quot;,
                &quot;contact_sub_type:label&quot;,
                &quot;GROUP_CONCAT(DISTINCT Contact_ContributionSoft_contact_id_01.soft_credit_type_id:label) AS GROUP_CONCAT_Contact_ContributionSoft_contact_id_01_soft_credit_type_id_label&quot;
              ],
              &quot;orderBy&quot;: [],
              &quot;where&quot;: [
                [
                  &quot;Contact_ContributionSoft_contact_id_01.soft_credit_type_id:name&quot;,
                  &quot;=&quot;,
                  &quot;pcp&quot;
                ]
              ],
              &quot;groupBy&quot;: [
                &quot;id&quot;
              ],
              &quot;join&quot;: [
                [
                  &quot;ContributionSoft AS Contact_ContributionSoft_contact_id_01&quot;,
                  &quot;INNER&quot;,
                  [
                    &quot;id&quot;,
                    &quot;=&quot;,
                    &quot;Contact_ContributionSoft_contact_id_01.contact_id&quot;
                  ]
                ]
              ],
              &quot;having&quot;: []
            }
          }
        ],
        &quot;match&quot;: [
          &quot;name&quot;
        ]
      }
    ]
  ]
  </code></pre>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-12-22T17:18:07.683Z
Answers.LastActivityDate: 2023-12-22T17:18:07.683Z
Answers.UserDisplayName: Francesc Bassas i Bullich
Body: <p>I can see a list of everyone who gave in honor of a specific person by looking at that contact's Contributions tab (under Soft Credits).  However, I can't figure out how to put these folks into a group, or even generate a report on them to see their contact info.  How do I do this?</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-09-18T15:28:41.747Z
Comments.Text: I can see that the "Soft Credit Report" allows me to search by "Soft Credit Name" - this is the direction I want, but I need to send a postal mailing to these folks, and the postal address isn't in this report.
Comments.UserDisplayName: Jon G - Megaphone Tech
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-09-18T19:11:56.147Z
Comments.Text: Did you check using Views?
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-09-19T00:25:11.343Z
Comments.Text: Can you create a Group "Soft Credit Smith", Run the "Soft Credit Report" to get the list of contacts you want, then over the right "+ Add Contacts To Group". Then do a mailing for that Group?
Comments.UserDisplayName: Iowa Boy
Tags: <civicontribute><soft-credit>
Title: How can I create a group of everyone who gave in honor of a specific person?
ThreadText: # How can I create a group of everyone who gave in honor of a specific person?
  
  (Asked by: username_0 on 2017-09-18)
  
  I can see a list of everyone who gave in honor of a specific person by looking at that contact's Contributions tab (under Soft Credits). However, I can't figure out how to put these folks into a group, or even generate a report on them to see their contact info. How do I do this?
  
  **Tags:** civicontribute, soft-credit
  
  > **Comments:**
  > **username_0**: I can see that the "Soft Credit Report" allows me to search by "Soft Credit Name" - this is the direction I want, but I need to send a postal mailing to these folks, and the postal address isn't in this report.  
  > **username_1**: Did you check using Views?  
  > **username_2**: Can you create a Group "Soft Credit Smith", Run the "Soft Credit Report" to get the list of contacts you want, then over the right "+ Add Contacts To Group". Then do a mailing for that Group?  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_0 on 2019-06-17. Score: 4
  
  I wrote an extension [Soft Credit Custom Fields](https://github.com/MegaphoneJon/com.megaphonetech.softcreditcustomfields) which, amongst other things, adds a "Soft Creditee's Name" field to the Advanced Search.
  
  
  ---
  
  ### Answer by username_3 on 2023-12-22. Score: 1
  
  With SearchKit it's possible to create the smart group without the help of the extension:
  [
    [
      "SavedSearch",
      "save",
      {
        "records": [
          {
            "name": "Fundraisers_P2P",
            "label": "Fundraisers P2P",
            "api_entity": "Contact",
            "api_params": {
              "version": 4,
              "select": [
                "id",
                "sort_name",
                "contact_type:label",
                "contact_sub_type:label",
                "GROUP_CONCAT(DISTINCT Contact_ContributionSoft_contact_id_01.soft_credit_type_id:label) AS GROUP_CONCAT_Contact_ContributionSoft_contact_id_01_soft_credit_type_id_label"
              ],
              "orderBy": [],
              "where": [
                [
                  "Contact_ContributionSoft_contact_id_01.soft_credit_type_id:name",
                  "=",
                  "pcp"
                ]
              ],
              "groupBy": [
                "id"
              ],
              "join": [
                [
                  "ContributionSoft AS Contact_ContributionSoft_contact_id_01",
                  "INNER",
                  [
                    "id",
                    "=",
                    "Contact_ContributionSoft_contact_id_01.contact_id"
                  ]
                ]
              ],
              "having": []
            }
          }
        ],
        "match": [
          "name"
        ]
      }
    ]
  ]
  
  
  ---
  
  