Manage Learn to apply best practices and optimize your operations.

Deleting Duplicate Documents

There will be many instances when one wants to find the duplicate documents & keep the latest (the most current) of them & delete the rest from the DB. This can be achevied by the following simple agent.

The most current is defined by a field called "AppDate".The unique identifier here is "DocNumber".

Create documents having same "DocNumber"& different "AppDate"s using a form & run this agent. The rest is done.

Big:=@Subset(AllDup;-1)-[01/01/2000 01:01:01AM];
Current:=AppDate-[01/01/2000 01:01:01AM];
@If(Current = Big;"";@DeleteDocument);

--View Duplicate has two columns,the first column is sorted on "DocNumber",the second is sorted on "AppDate"(Ascending order).

Note: This only works when "AppDate" is greater than the given date(01/01/2000).

Dig Deeper on Lotus Notes Domino Formula Language



  • Favorite iSeries cheat sheets

    Here you'll find a collection of valuable cheat sheets gathered from across the iSeries/ community. These cheat ...

  • HTML cheat sheet

    This is a really cool cheat sheet if you're looking to learn more about HTML. You'll find just about everything you every wanted ...

  • Carol Woodbury: Security

    Carol Woodbury