Answers.Body: <p>You can use wildcard characters (%xxxx%) in search to change the default operator of "=" to "LIKE" - e.g. on <a href="https://dmaster.demo.civicrm.org" rel="nofollow noreferrer">demo</a>:</p>
  
  <p><strong>Using Search > Find Activities:</strong></p>
  
  <ol start="2">
  <li>Activity Text = Tell a Friend</li>
  <li>Status = Scheduled, Completed</li>
  <li><p>Generates the same query as you listed in your question and at the time I write results in 204 records:</p>
  
  <p>Activity targeted to ...AND...</p>
  
  <p>Activity Text (Subject Only) Like '%Tell a Friend%' ...AND...</p>
  
  <p>Activity Status In Scheduled, Completed</p></li>
  </ol>
  
  <p>The same query is generated when using  <strong>Search > Advanced Search</strong> with the following parameters:</p>
  
  <ol>
  <li>Activity Text = %Tell a Friend%</li>
  <li>Status = Scheduled, Completed</li>
  </ol>
  
  <p>The above returns 89 contacts, but if you display the results as activities, you get the same 204 that you did using <strong>Search > Find Activities.</strong></p>
  
  <p>Hope this helps,
  Tamar</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-10-17T12:32:40.610Z
Answers.Text: Thank you, that does help (and works of course). It is a little odd that that field is no longer a 'contains' search - as I'm not sure you'd likely have the details of an activity as an exact string. While the wildcard search absolutely works it seems it might be an extra step. I might submit it as a bug to see if the team believes that the behavior is worth adjusting.
Answers.UserDisplayName: RayWright
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-10-17T17:07:34.720Z
Answers.Text: Hi Ray, the team would most likely consider this an improvement and as it would not be considered critical, would move it to the paid issue queue - a label that fixes and improvements that are prioritized by the core team and requires funding/contributed fix from the community, but glad I was able to help you in any case.
Answers.UserDisplayName: Tamar Meir - Cividesk
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-10-15T21:36:20.990Z
Answers.LastActivityDate: 2018-10-15T23:03:44.193Z
Answers.LastEditDate: 2018-10-15T23:03:44.193Z
Answers.UserDisplayName: Tamar Meir - Cividesk
Body: <p>I've noticed the upgrade to the activity search now lets you search either the Subject or details of an activity (I'm in Civi 5.5.3, Drupal 7.59) which is great but on the Advanced search screen it seems to use the strict "=" qualifier.</p>
  
  <p>I've verified the following behavior of the demo site (5.8) as well:</p>
  
  <ul>
  <li>Run an Advanced search for an activity that contains "Tell a Friend" in the subject line - <strong>no results</strong>.</li>
  <li>Run an activity search for an activity that contains "Tell a Friend" in the subject line - returns all the activities that subject line contains the search term, including "Subject for Tell a Friend".</li>
  <li>Same problem when you search details or both.</li>
  </ul>
  
  <p>I can see in feedback for the the blank search results:</p>
  
  <pre><code>No matches found for:
  Activity targeted to ...AND...
  Activity Text (Subject Only) = 'Tell a Friend' ...AND...
  Activity Status In Completed
  </code></pre>
  
  <p>Versus the summary that shows on the full set of results:</p>
  
  <pre><code>Activity targeted to ...AND...
  Activity Text (Subject Only) Like '%Tell a Friend%' ...AND...
  Activity Status In Completed
  </code></pre>
  
  <p>I'd like to use advanced search so that I can return contact results and add them to a group. Any idea where I take a look to change the Advanced Search from "=" to "LIKE"?</p>
  
  <p>Also, any idea if this was intentional behavior - it doesn't seem like it would be very useful but maybe that's me? Is this worthy of a bug report?</p>
  
Tags: <activities><search>
Title: Activity search by subject - advanced search vs activity search
ThreadText: # Activity search by subject - advanced search vs activity search
  
  (Asked by: username_0 on 2018-10-15)
  
  I've noticed the upgrade to the activity search now lets you search either the Subject or details of an activity (I'm in Civi 5.5.3, Drupal 7.59) which is great but on the Advanced search screen it seems to use the strict "=" qualifier.
  I've verified the following behavior of the demo site (5.8) as well:
  
  Run an Advanced search for an activity that contains "Tell a Friend" in the subject line - no results.
  Run an activity search for an activity that contains "Tell a Friend" in the subject line - returns all the activities that subject line contains the search term, including "Subject for Tell a Friend".
  Same problem when you search details or both.
  
  I can see in feedback for the the blank search results:
  No matches found for:
  Activity targeted to ...AND...
  Activity Text (Subject Only) = 'Tell a Friend' ...AND...
  Activity Status In Completed
  
  Versus the summary that shows on the full set of results:
  Activity targeted to ...AND...
  Activity Text (Subject Only) Like '%Tell a Friend%' ...AND...
  Activity Status In Completed
  
  I'd like to use advanced search so that I can return contact results and add them to a group. Any idea where I take a look to change the Advanced Search from "=" to "LIKE"?
  Also, any idea if this was intentional behavior - it doesn't seem like it would be very useful but maybe that's me? Is this worthy of a bug report?
  
  **Tags:** activities, search
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2018-10-15. Score: 2 | Accepted answer
  
  You can use wildcard characters (%xxxx%) in search to change the default operator of "=" to "LIKE" - e.g. on [demo](https://dmaster.demo.civicrm.org):
  
  **Using Search > Find Activities:**
  
  2. Activity Text = Tell a Friend
  3. Status = Scheduled, Completed
  4. Generates the same query as you listed in your question and at the time I write results in 204 records:
  
     Activity targeted to ...AND...
  
     Activity Text (Subject Only) Like '%Tell a Friend%' ...AND...
  
     Activity Status In Scheduled, Completed
  
  The same query is generated when using **Search > Advanced Search** with the following parameters:
  
  1. Activity Text = %Tell a Friend%
  2. Status = Scheduled, Completed
  
  The above returns 89 contacts, but if you display the results as activities, you get the same 204 that you did using **Search > Find Activities.**
  
  Hope this helps,
  Tamar
  
  > **Comments:**
  > **username_0**: Thank you, that does help (and works of course). It is a little odd that that field is no longer a 'contains' search - as I'm not sure you'd likely have the details of an activity as an exact string. While the wildcard search absolutely works it seems it might be an extra step. I might submit it as a bug to see if the team believes that the behavior is worth adjusting.  
  > **username_1**: Hi Ray, the team would most likely consider this an improvement and as it would not be considered critical, would move it to the paid issue queue - a label that fixes and improvements that are prioritized by the core team and requires funding/contributed fix from the community, but glad I was able to help you in any case.  
  
  ---
  
  