CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Search Customer with Activity > 1
Pages: [1]

Author Topic: Search Customer with Activity > 1  (Read 345 times)

markjohan

  • I post occasionally
  • **
  • Posts: 102
  • Karma: 0
  • ..
  • CiviCRM version: 4.4.2
  • CMS version: Wordpress 3.6.1
  • MySQL version: 5.1.66-0+squeeze1
  • PHP version: 5.3.27
Search Customer with Activity > 1
February 16, 2015, 09:13:50 am
Hello,

Is it possible to search for contacts in the CRM that has more than 1 activity?
(So i can search people who has ordered more than ones.)


Thanks.

Erik Hommel

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1773
  • Karma: 59
    • EE-atWork
  • CiviCRM version: all sorts
  • CMS version: Drupal
  • MySQL version: Ubuntu's latest LTS version
  • PHP version: Ubuntu's latest LTS version
Re: Search Customer with Activity > 1
February 17, 2015, 12:08:24 am
You can do that in Advanced Search? Open the Activities tab and select for example 'Assigned To' ? The result should show you any contact that has at least one activity assigned to it?
Consultant/project manager at EEatWork and CiviCooP (http://www.civicoop.org/)

markjohan

  • I post occasionally
  • **
  • Posts: 102
  • Karma: 0
  • ..
  • CiviCRM version: 4.4.2
  • CMS version: Wordpress 3.6.1
  • MySQL version: 5.1.66-0+squeeze1
  • PHP version: 5.3.27
Re: Search Customer with Activity > 1
February 17, 2015, 04:14:59 am
Hello Erik,

Thanks, but i don't have a Activities Tab.. And i want to search for contacts who has more than 1.

So if a contact had made just 1 order, it is not important to contact him/her.

So it is important to search people who did made more than 1 activity.

I hope someone can help me with this.

Thanks.

Erik Hommel

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1773
  • Karma: 59
    • EE-atWork
  • CiviCRM version: all sorts
  • CMS version: Drupal
  • MySQL version: Ubuntu's latest LTS version
  • PHP version: Ubuntu's latest LTS version
Re: Search Customer with Activity > 1
February 17, 2015, 05:06:07 am
Can you tell me what you need functionally? And you should really have an Activities Tab in advanced search (see screen print from demo site)
Consultant/project manager at EEatWork and CiviCooP (http://www.civicoop.org/)

markjohan

  • I post occasionally
  • **
  • Posts: 102
  • Karma: 0
  • ..
  • CiviCRM version: 4.4.2
  • CMS version: Wordpress 3.6.1
  • MySQL version: 5.1.66-0+squeeze1
  • PHP version: 5.3.27
Re: Search Customer with Activity > 1
February 17, 2015, 05:37:10 am
Hello Erik,

Thanks for your reply.
I have checked other sites from me, and there is indeed a activity tab.

But that still does not help me. I do not search for an activity but for contacts who have more than 1 or more than 2 activities.

For example, if you go to a contact, you will see the tab Activities, and there is a number behind.
There is no way to search for that number?

Thanks.

Erik Hommel

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1773
  • Karma: 59
    • EE-atWork
  • CiviCRM version: all sorts
  • CMS version: Drupal
  • MySQL version: Ubuntu's latest LTS version
  • PHP version: Ubuntu's latest LTS version
Re: Search Customer with Activity > 1
February 17, 2015, 05:57:37 am
No, not in the standard search options
Consultant/project manager at EEatWork and CiviCooP (http://www.civicoop.org/)

Erik Hommel

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1773
  • Karma: 59
    • EE-atWork
  • CiviCRM version: all sorts
  • CMS version: Drupal
  • MySQL version: Ubuntu's latest LTS version
  • PHP version: Ubuntu's latest LTS version
Re: Search Customer with Activity > 1
February 17, 2015, 05:58:29 am
but it is quite easy to get the number, and most organizations we work with would get stuff like that using Drupal Views to display it on their website? What CMS are you using?
Consultant/project manager at EEatWork and CiviCooP (http://www.civicoop.org/)
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Search Customer with Activity > 1

This forum was archived on 2017-11-26.