CiviCRM Community Forums (archive)

That title was a mouthful...

I have individuals that are set up via relationships as Employees Of organizations. Some of these organizations are members of a group. I want to be able to do a search that comes up with all of the individuals that belong to organizations that are members of a specific group. Confused yet?

For example:
Jon, Frank, and Mary are employees of Alabama Program, Mississippi Program, and Florida Program, respectively (via relationships). Those programs (organizations) are all member of the group 'NE Region'. I want to be able to somehow search for all individuals that belong to an organization that is in the NE Region group. In this case, I want Jon, Frank, and Mary to come up.

We want to be able to email all individuals that are employed by all organizations that are in the group NE Region, we don't want to just email the organizations themselves.

Any thoughts on how best to do this?

Hi,

Do note that the current employer company id is stored in the individual records, ie you don't have to join on the relationship to fetch the list.

Essentially, if you find the query to fetch the contacts in a group, replace the civicrm_contact.contact_id by civicrm_contact.employer_id in the join, you got it.

Please share the result, I can imagine having other people using it

X+