helpphpGroupWare - Support: sr #102412, Addressbook - filter to aid db...


You are not allowed to post comments on this tracker with your current authentication level.

sr #102412: Addressbook - filter to aid db cleanup

Submitted by:  Johnson <jecinc>
Submitted on:  Mon 08 Sep 2003 06:57:14 PM UTC  
Category:  Feature Request Priority:  5 - Normal
Severity:  2 - Minor Status:  None
Privacy:  Public Assigned to:  Alejandro Borges (lex) <alexbsa>
Open/Closed:  Open Operating System:  None

Thu 11 Sep 2003 03:58:05 PM UTC, comment #2: 

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

Johnson <jecinc>
Wed 10 Sep 2003 11:08:17 PM UTC, comment #1: 

Great idea, ill see what can be done

Alejandro Borges (lex) <alexbsa>In charge of this item.
Mon 08 Sep 2003 06:57:14 PM UTC, original submission:  

Could we have a builtin filter (maybe a button
available to admins) that displays all the records that
have duplicate firstname+lastname for persons and
duplicate company name for orgs to allow the abmin to
view, edit, delete them (to help with db cleanup)

Johnson <jecinc>


No files currently attached


Depends on the following items: None found

Items that depend on this one: None found


CC list is empty


Do you think this task is very important?
If so, you can add your encouragement to it.
This task has 0 encouragements so far.

Only logged-in users can vote.




Follows 1 latest change.

Date Changed by Updated Field Previous Value => Replaced by
2003-09-09 skwashd Assigned toNone => NA

Back to the top

Powered by Savane 3.7