mainphpGroupWare - 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

Submitter:  Johnson <jecinc>
Submitted:  Mon 08 Sep 2003 06:57:14 PM UTC
   
 
Category:  Feature Request Priority:  5 - Normal
Severity:  2 - Minor Status:  None
Privacy:  Public Assigned to:  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>
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>

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

 

Follows 1 latest change.

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

Back to the top

Powered by Savane 3.13-3230.
Corresponding source code