: 4582 | 108668 | 12353

Identify and or filter out duplicates in a view. 
Use this IdeaSpace to post ideas about Domino Designer.

: 4
: 8
: 4
: Domino Designer
: View, duplicates
: Carl Rizzo1428 14 Feb 2010
: / Email
Not sure how possible it is, but I have had many occasions where I would like to identify and delete duplicate documents in a view.  Thanks

1) Philip Storry849 (15 Feb 2010)
Define duplicate? Do you mean anything with exactly the same details in a view? Sort of like a "View -> Show -> Duplicates only", to go along with selected and unread?

I'm in two minds about this one. But I'll vote yes, as it could also be useful in the Domino Directory for finding goofs there...
2) Carl Rizzo1428 (15 Feb 2010)
Hi Phil,

For what I run into the docs are exact duplicates, but it would be nice if there was a way to compare field values from one doc to another to determine duplicates. Thank you.
3) Paul Davies12381 (17 Feb 2010)
if you are filtering out duplicates, then what exactly do you need the duplicate document for?

de-duping a db isn't very difficult. The technique I often use is to use a view which shows the NoteID of the docs, export the view to a CSV, use MS Access Find Duplicates query wizard (followed up with a Select Max() query) to identify the lines you want to delete, export the NoteIds of those lines back to a single or multiple document (depending on how may etc) and then use an agent to loop through and mark those documents with a flag so you can be sure it has identified the correct docs, then if satisfied, delete the docs with the flag
4) Carl Rizzo1428 (17 Feb 2010)
Hi Paul,
Wow that is very smart, but also very complicated. I can follow the logic and I am sure it works, but I was looking for something easier. You are correct in that I would never need the duplicate doc. I just wanted it flagged so I can see it and I can delete it. Thanks.
5) Paul Davies12381 (17 Feb 2010)
Carl - I suppose only you can define what a duplicate is in your own context. no two notes documents are exactly the same as they will have different IDs and timestamps etc.

Does setting the property 'Force Unique IDs in index for ODBC access' give you what you want? This filters out duplicates in the first (sorted?) column. Its in the last property page for the view
6) Carl Rizzo1428 (17 Feb 2010)
Hi Paul,

Yes, I think that would work. I did not know that is how that feature worked. I had no idea. Thanks.
7) Bill Malchisky9254 (25 Feb 2010)
Also @Unique works, depending upon your needs.


Welcome to IdeaJam

You can run IdeaJam™ in your company. It's easy to install, setup and customize. Your employees, partners and customers will immediately see results.

Use IdeaJam to:

  • Collect ideas from employees
  • Solicit feedback and suggestions from employees and customers
  • Run innovation contests and competitions
  • Validate concepts
  • Use the power of "crowd-sourcing" to rank ideas and allow the best ideas to rise to the top

IdeaJam™ works with:

  • IBM Connections
  • IBM Lotus Quickr
  • Blogs and Wikis
  • Websphere Portal
  • Microsoft Sharepoint
  • and other applications.

IdeaJam has an extensive set of widgets and API's that allow you to extend and integrate IdeaJam™ with other applications.

Learn more about IdeaJam >>

IdeaJam developed by

Elguji Software Logo