7

How can I setup a Smart Group to include members based on relative dates (e.g. last Activity)?

When I try to use relative date, e.g. Yesterday in advanced search, it correctly finds users with Activity on previous day, but when I create a Smart Group out of that search, it seems to fix the date in search criteria. As a result the next day smart group now contains members with Activity on the day before yesterday.

Neither running Rebuild Smart Group Cache (no parameters) nor clicking Update Smart Group Counts helped.

Am I missing something obvious?

Wordpress: 4.5.3 CiviCRM: 4.7.9

enter image description here

Tried to create a Smart Group in CiviCRM Sandbox on Drupal and it seems Activity Date gets fixed immediately when trying to create a Smart Group from Advanced Search. enter image description here

Improve this question
  • 2
    Your query is similar to this question although because the author had stated their intentions they were able to get a workaround. You're correct that the search and smart group function doesn't keep the smart group dates as a relative search and instead translates it but, if you're able to, could you expand on your question and let people know what you're trying to achieve? – Matt Lind Aug 18 '16 at 13:18
  • @MattLind I am afraid that the scale of my intentions will prohibit simple workaround. I'd like to create multiple smart groups in such a way that a contact is changing the groups (depending on the relative time of activities). – Aivars Aug 18 '16 at 14:00
  • 1
    Sounds fun =) What will you be looking to do with the contacts when they are in the different smart groups? e.g. If it's just a case of seeing people's relative time from an activitiy then reports might be a better place to look. – Matt Lind Aug 18 '16 at 15:10
  • I'd like to use multiple parameters for filtering users. E.g. Group A: Activity X, if before 30 days. Group B: Activity X, if during last 30 days. Group C: Activity Y, if before 14 days. Group D: Activity Y, if during 14 days. It is not that I'd like to only see relative time of all people. I'd rather like to see people in different categories, depending on multiple parameters (often 3 or 4), so that I can meaningfully interact with each category. – Aivars Aug 18 '16 at 15:12
5

This was a bug in Core CiviCRM which is now fixed starting from version 4.7.14.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.