Index: openacs-4/packages/address-book/www/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/address-book/www/index-postgresql.xql,v
diff -u -N -r1.2 -r1.3
--- openacs-4/packages/address-book/www/index-postgresql.xql	28 Aug 2001 23:51:54 -0000	1.2
+++ openacs-4/packages/address-book/www/index-postgresql.xql	1 Sep 2001 20:34:19 -0000	1.3
@@ -9,5 +9,26 @@
       </querytext>
 </fullquery>
 
+<fullquery name="sql_query">
+  <querytext>
+    select contact_id,
+           coalesce(last_name,'<br>') as last_name,
+           coalesce(first_names,'<br>') as first_names,
+           coalesce(title,'<br>') as title,
+           coalesce(organization,'<br>') as organization,
+           coalesce(work_phone,'<br>') as work_phone,
+           coalesce(home_phone,'<br>') as home_phone,
+           coalesce(fax,'<br>') as fax,
+           coalesce(other,'<br>') as other,
+           coalesce(email,'<br>') as email,
+           acs_permission__permission_p(acr.rel_id,:user_id,'delete') as delete_p,
+           acr.rel_id
+      from ab_contacts_related acr
+     where acs_permission__permission_p(contact_id,:user_id,'read') = 't'
+       and object_id = :instance_id
+      [value_if_exists search_filter]
+  </querytext>
+</fullquery>
  
+ 
 </queryset>