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) »
  • Finding organizations with no employees
Pages: [1]

Author Topic: Finding organizations with no employees  (Read 1108 times)

tobiaseigen

  • I post frequently
  • ***
  • Posts: 151
  • Karma: 5
    • Kabissa - Space for Change in Africa
Finding organizations with no employees
January 13, 2010, 05:29:18 am
Hi all,

Happy New Year.

I am seeking to find all organizations in my 2.2.2 civi database that have no employees, so that I can review and probably delete them. I may also need to identify orgs that have employees with no drupal account.

I've been poking around in the backend with no success. Any suggestions on how to do this most welcome!

Thanks,

Tobias
Kabissa - Space for Change in Africa http://kabissa.org

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Finding organizations with no employees
January 13, 2010, 01:15:22 pm
Make a Group A = all orgs
Make a Group B = all orgs with Relationship = Employer of

Make an A-B Group.

Maybe???
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

tobiaseigen

  • I post frequently
  • ***
  • Posts: 151
  • Karma: 5
    • Kabissa - Space for Change in Africa
Re: Finding organizations with no employees
January 21, 2010, 02:49:34 am
Hi peterd - thanks for the reply. Can you explain? I don't understand how this could work, or give different results than simply doing an advanced search for orgs with relationship = employer. What I need is all orgs with relationship = employees none.

-T
Kabissa - Space for Change in Africa http://kabissa.org

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Finding organizations with no employees
January 21, 2010, 10:19:52 am
If you make a Group with All Orgs in it, and also make a Group with only Orgs with an Employee - and then use Custom Search to Include Group with All Orgs and Exclude Group with Employees then it looks to me like you will end up with All Orgs with No Employees.
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Finding organizations with no employees

This forum was archived on 2017-11-26.