Author Topic: Searching for person being NOT in household (Read 640 times)

behrang · November 19, 2011, 03:47:04 am

Hi
i been playing around with the searches at civicrm and didnt find so maybe i'm blind.
but is there actually anyway to search for person being NOT member of any household?

I'm searching for members of a group and would like to have households and "single"-Non-household person.
Right now I get many duplicates (i.e. the households AND their members) since merging for pdf letter is not available!

so i wondered how i could split the two "problems".

I can get the households being member of a group by search generator.
but how could i get the "single"-Non-household person?
any ideas?

Donald Lobo · November 19, 2011, 06:57:04 am

Might be better in the long run in folks spend the extra hours (or euros) and add functionality like "merging for pdf letters" rather than a work-around. Will benefit you and the community

One potential way might be:

1. Tag all individuals with a Tag IND
2. Do a search and find all individuals that belong to a household. For all these individuals, remove the tag IND
3. Do a search with individuals Tag IND. These are your individuals that dont belong to a household

lobo

xavier · November 19, 2011, 08:28:59 am

Hi,

if you can write a custom search, you can so a

Code: [Select]

select ... from civicrm_contacts where not exists (select id from civicrm_relationship where id=contact_id_a & relationship_type = household);

You'll have to investigate the real id for household member and probably deal with contact a and contact b in the table), but select where not exist (select should do it).

X+

CiviCRM Community Forums (archive)

News:

Author Topic: Searching for person being NOT in household (Read 640 times)

behrang

Searching for person being NOT in household

Donald Lobo

Re: Searching for person being NOT in household

xavier

Re: Searching for person being NOT in household