Index: openacs-4/packages/contacts/www/admin/search-list.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/contacts/www/admin/search-list.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/contacts/www/admin/search-list.xql 11 Nov 2005 22:57:43 -0000 1.1 +++ openacs-4/packages/contacts/www/admin/search-list.xql 17 Nov 2005 18:22:02 -0000 1.2 @@ -3,16 +3,16 @@ -( select search_id, title, upper(title) as order_title, all_or_any, object_type +( select search_id, title, upper(title) as order_title, all_or_any, object_type, owner_id from contact_searches - where owner_id = :owner_id - and title is not null + where + title is not null and not deleted_p ) union ( - select search_id, 'Search \#' || to_char(search_id,'FM9999999999999999999') || ' on ' || to_char(creation_date,'Mon FMDD') as title, 'zzzzzzzzzzz' as order_title, all_or_any, contact_searches.object_type + select search_id, 'Search \#' || to_char(search_id,'FM9999999999999999999') || ' on ' || to_char(creation_date,'Mon FMDD') as title, 'zzzzzzzzzzz' as order_title, all_or_any, contact_searches.object_type, owner_id from contact_searches, acs_objects - where owner_id = :owner_id - and search_id = object_id + where + search_id = object_id and contact_searches.title is null and not deleted_p limit 10