Lotus Notes FAQ


How do you remove orphan response documents?

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

Run this as a nightly agent:

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

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

Home *Notes V3 *Notes V4 *Notes/Domino 4.5
Last Modified: May 10, 1997