Index: openacs-4/packages/contacts/tcl/contact-search-procs.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/contacts/tcl/contact-search-procs.xql,v diff -u -r1.10 -r1.11 --- openacs-4/packages/contacts/tcl/contact-search-procs.xql 15 Feb 2006 10:06:36 -0000 1.10 +++ openacs-4/packages/contacts/tcl/contact-search-procs.xql 12 Mar 2006 17:54:18 -0000 1.11 @@ -34,7 +34,7 @@ - + select count(distinct party_id) from parties left join cr_items on (parties.party_id = cr_items.item_id) left join cr_revisions on (cr_items.latest_revision = cr_revisions.revision_id ) , group_distinct_member_map @@ -44,12 +44,37 @@ - + + select count(distinct person_id) + from persons, cr_items, cr_revisions, group_distinct_member_map + where persons.person_id = group_distinct_member_map.member_id + and group_distinct_member_map.group_id in ('[join [contacts::default_groups] "','"]') + and persons.person_id = cr_items.item_id + and cr_items.latest_revision = cr_revisions.revision_id + [contact::search_clause -and -search_id $search_id -query $query -party_id "parties.party_id" -revision_id "revision_id"] + + + + + + select count(distinct organization_id) + from organizations, cr_items, cr_revisions, group_distinct_member_map + where organizations.organization_id = group_distinct_member_map.member_id + and group_distinct_member_map.group_id in ('[join [contacts::default_groups] "','"]') + and organizations.organization_id = cr_items.item_id + and cr_items.latest_revision = cr_revisions.revision_id + [contact::search_clause -and -search_id $search_id -query $query -party_id "parties.party_id" -revision_id "revision_id"] + + + + + + select - distinct type + object_type from - contact_search_conditions + contact_searches where search_id = :search_id