One of the user in Notes 6 forum asked how to keep unique records in the view. I have given very simple solution , In view's advanced tab try to check "Generate unique keys in Index" check box.

I have noticed still people thinks this option is only for ODBC. But believe me it works well to keep unique records in the view. Hidden tips :)

Here is the conversation ,

2 Responses to "Unique record in the views"

  1. gravatar Ulrich Krause Says:

    This will work and I used it a lot of times. But I remember that I sometimes ran into a "64k" error when there were plenty of view entries. So be careful when using this option.

  2. gravatar Rishi Says:


    You are right IBM doesn't provide this option for such common use. First if your view having duplicate documents , It means your application is not designed properly.By enabling this option definitely you will face performance issue. This option mainly used to push unique documents into ODBC when view is mapped with Db2.

Leave a Reply

preload preload preload