Search code examples
lotus-noteslotus-dominolotusscriptlotuslotus-formula

Lotus Notes - Find similar Fields (SELECTION)

I'm trying to make a view that will display possible duplicate documents. So a selection formula that compares one field over all the documents and only diplays those that are similar.

I ahve been playing arond with @Like and @Matches, but can't seem to get it to work. Is this possible?

Thanks

Solution

  • You can't reference from a view selection formula to other documents. The selection formula works only for the current document and decides if this document shall be visible in view.

    You can write an agent which compares all documents with all the other documents and sets a flag (=item/field) to a document if it has similar fields with the other documents. You can then select all those flagged documents in your view.