Index: openacs-4/packages/contacts/lib/contacts.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/contacts/lib/contacts.xql,v diff -u -r1.16 -r1.17 --- openacs-4/packages/contacts/lib/contacts.xql 15 Nov 2005 15:56:46 -0000 1.16 +++ openacs-4/packages/contacts/lib/contacts.xql 23 Nov 2005 17:28:44 -0000 1.17 @@ -51,9 +51,37 @@ - + + select distinct + $extend_query + rel.object_id_one as party_id, + rel.object_id_two as employee_id + from + acs_rels rel, + parties p + where + rel.rel_type = 'contact_rels_employment' + and rel.object_id_one = p.party_id + [template::list::page_where_clause -and -name "contacts" -key "party_id"] + + + + + select + rel.object_id_one as party_id, + rel.object_id_two as employee_id + from + acs_rels rel + where + rel.rel_type = 'contact_rels_employment' + + + + + + select object_type from contact_searches @@ -62,4 +90,26 @@ + + + select + object_type + from + contact_searches + where + search_id = :search_id + + + + + + select + type + from + contact_search_conditions + where + search_id = :search_id + + +