Body: <p>We are on WP 4.9.4 and Civi 4.7.29 multisite.</p>
  
  <p>There is incorrect behavior when trying to do a search on a smart group that is combining a activity type field and a custom field.</p>
  
  <p>We have 750 search results when searching the custom field alone. We have 19 contacts in the activity field.</p>
  
  <p>Therefore, you would expect at least 750 results when searching the smart group that combines the above fields. Instead, we get 124 results.</p>
  
  <p><a href="https://i.sstatic.net/SQ6vV.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/SQ6vV.png" alt="enter image description here"></a><a href="https://i.sstatic.net/SgSel.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/SgSel.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.sstatic.net/sT5oR.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/sT5oR.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.sstatic.net/o3NRC.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/o3NRC.png" alt="smart group settings"></a></p>
  
  <p>Here are the smart group settings.
  Has anyone seen this kind of behavior?</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2018-02-15T18:31:42.843Z
Comments.Text: have you tried via Search Builder? Have you ruled out that some Activities have multiple contacts on them?
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2018-02-16T15:56:24.237Z
Comments.Text: I tried to replicate the search the smart group should be doing in search builder (as I originally created the group in adv search) but it also gives a much smaller size of contacts than what should be showing.
Comments.UserDisplayName: Andy Burns
Tags: <search><smartgroups><issues>
Title: Search Irregularities
ThreadText: # Search Irregularities
  
  (Asked by: username_0 on 2018-02-15)
  
  We are on WP 4.9.4 and Civi 4.7.29 multisite.
  
  There is incorrect behavior when trying to do a search on a smart group that is combining a activity type field and a custom field.
  
  We have 750 search results when searching the custom field alone. We have 19 contacts in the activity field.
  
  Therefore, you would expect at least 750 results when searching the smart group that combines the above fields. Instead, we get 124 results.
  
  [![enter image description here](https://i.sstatic.net/SQ6vV.png)](https://i.sstatic.net/SQ6vV.png)[![enter image description here](https://i.sstatic.net/SgSel.png)](https://i.sstatic.net/SgSel.png)
  
  [![enter image description here](https://i.sstatic.net/sT5oR.png)](https://i.sstatic.net/sT5oR.png)
  
  [![smart group settings](https://i.sstatic.net/o3NRC.png)](https://i.sstatic.net/o3NRC.png)
  
  Here are the smart group settings.
  Has anyone seen this kind of behavior?
  
  **Tags:** search, smartgroups, issues
  
  > **Comments:**
  > **username_1**: have you tried via Search Builder? Have you ruled out that some Activities have multiple contacts on them?  
  > **username_0**: I tried to replicate the search the smart group should be doing in search builder (as I originally created the group in adv search) but it also gives a much smaller size of contacts than what should be showing.  
  
  ---
  
  ## 0 answers
  
  