Answers.Body: <p>It is not the ideal solution but so far has worked.</p>
  
  <ol>
  <li><p>Edit the search criteria for the affected/s smart group/s <em>- The search result remain empty</em></p></li>
  <li><p>Search again - <em>The search result will be good</em></p></li>
  <li><p>Update the smart group</p></li>
  </ol>
  
  <p>After this the smart/s group/s works correctly again.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-08-10T21:52:32.050Z
Answers.LastActivityDate: 2015-08-10T21:52:32.050Z
Answers.UserDisplayName: Francesc Bassas i Bullich
Body: <p>We upgrade recently from 4.5.8 to 4.6.6 on our CiviCRM instances.</p>
  <p>After that we note that some smart groups become empty. An example as proof:</p>
  <p><strong>Smart group has been emptied:</strong></p>
  <blockquote>
  <p>Event type = Centre Obert ...and...</p>
  <p>Start Date - greater than or equal to &quot;september 12th, 2013 12:00 AM&quot; ...and...</p>
  <p>End Date - less than or equal to &quot;juny 20th, 2014 11:59 PM&quot; ...and...</p>
  <p>Participant Status ID is Inscrit ...and...</p>
  <p>Participant Role is 1</p>
  </blockquote>
  <p>NOTE: Cleaning caches and rebuilding smart groups has not worked.</p>
  
Tags: <smartgroups>
Title: Why some of our smart groups are empty after CiviCRM upgrade?
ThreadText: # Why some of our smart groups are empty after CiviCRM upgrade?
  
  (Asked by: username_0 on 2015-08-10)
  
  We upgrade recently from 4.5.8 to 4.6.6 on our CiviCRM instances.
  
  After that we note that some smart groups become empty. An example as proof:
  
  **Smart group has been emptied:**
  
  > Event type = Centre Obert ...and...
  >
  > Start Date - greater than or equal to "september 12th, 2013 12:00 AM" ...and...
  >
  > End Date - less than or equal to "juny 20th, 2014 11:59 PM" ...and...
  >
  > Participant Status ID is Inscrit ...and...
  >
  > Participant Role is 1
  
  NOTE: Cleaning caches and rebuilding smart groups has not worked.
  
  **Tags:** smartgroups
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2015-08-10. Score: 1
  
  It is not the ideal solution but so far has worked.
  
  1. Edit the search criteria for the affected/s smart group/s *- The search result remain empty*
  2. Search again - *The search result will be good*
  3. Update the smart group
  
  After this the smart/s group/s works correctly again.
  
  
  ---
  
  