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 RequestPriority: 5 - Normal
Severity: 2 - MinorStatus: None
Privacy: PublicAssigned to: Alejandro Borges (lex) <alexbsa>
Open/Closed: OpenOperating 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 click here to add your encouragement to it.
This task has 0 encouragements so far.

Only logged-in users can vote.

 

Please enter the title of George Orwell's famous dystopian book (it's a date):

 

 

Follows 1 latest change.

Date Changed By Updated Field Previous Value => Replaced By
Tue 09 Sep 2003 07:49:10 AM UTCskwashdAssigned toNone=>NA

Back to the top


Powered by Savane 3.1-cleanup1