CODEWITHSUNDEEP
lotus-noteslotus-dominolotusscriptlotuslotus-formula
ClaaziX
ClaaziX

Reputation: 113

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

Upvotes: 1

Views: 115

Answers (2)

Karl-Henry Martinsson
Karl-Henry Martinsson

Reputation: 2795

You can create a view where the first (sorted) column contains the field you want to check against. Then use @SetViewInfo to filter the view to only show documents matching a specific value.

Upvotes: 0

Knut Herrmann
Knut Herrmann

Reputation: 30960

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.

Upvotes: 3

Related Questions