Search for duplicate entries

[RandyJ]

Is there a method or module that allows a client to search the database for duplicates in a particular field? and further, to discard the duplicates?

[Ben]

Hey Randy.

Good question, lousy answer: no. Sorry about that.

There's a function in the API to detect for uniqueness while you're adding a submission (e.g. check an email isn't used, or a first-name-last-name combo or something), but that's only done on a one-by-one basis. You need a script that parses the entire content of a form.

This is definitely a job for a module. I'll make a note of it for future module ideas.

Sorry I couldn't be more help, Randy.

- Ben