Lotus Notes FAQ Visit Our Sponsor!

How do you remove orphan response documents?

You need a hidden view named (UNID) which has one column with a formula of:

Run this as a nightly agent:

  SELECT @IsAvailable($Ref) &
    @IsError(@DbLookup("" : "NOCACHE"; "";"(UNID)"; @Text($REF); 1));

It will find and delete all orphans using this hidden view.

Applies to Notes Versions: 3
Last Modified: May 10, 1997