[Phpgroupware-tracker] [support #102412] Addressbook - filter to aid db cleanup

[nobody]

Support Request #102412, was updated on Mon 09/08/2003 at 18:57
You can respond by visiting: 
http://savannah.gnu.org/support/?func=detailsupport&support_id=102412&group_id=509

Category: Feature Request
Status: Open
Priority: 5
Summary: Addressbook - filter to aid db cleanup

By: jecinc
Date: Thu 09/11/2003 at 15:58
Logged In: YES 
user_id=10780
Browser: Mozilla/5.0 Galeon/1.2.7 (X11; Linux i686; U;) Gecko/20030131

example SQL for the persons:



SELECT first_name, last_name, (first_name || ' ' ||

last_name) AS full_name FROM phpgw_contact_person GROUP BY

full_name HAVING count(full_name) > 1;



needs a db specific concat function

----------------------------------------------------------------------

By: alexbsa
Date: Wed 09/10/2003 at 23:08
Logged In: YES 
user_id=3521
Browser: Mozilla/5.0 (X11; U; Linux ppc; en-US; rv:1.4) Gecko/20030827 
Epiphany/0.8.4

Great idea, ill see what can be done



----------------------------------------------------------------------
You can respond by visiting: 
http://savannah.gnu.org/support/?func=detailsupport&support_id=102412&group_id=509

_______________________________________________
  Message sent via/by Savannah
  http://savannah.gnu.org/