Skip to Main Content
HCL Domino Ideas Portal

Welcome to the #dominoforever Product Ideas Forum! The place where you can submit product ideas and enhancement request. We encourage you to participate by voting on, commenting on, and creating new ideas. All new ideas will be evaluated by HCL Product Management & Engineering teams, and the next steps will be communicated. While not all submitted ideas will be executed upon, community feedback will play a key role in influencing which ideas are and when they will be implemented.

For more information and upcoming events around #dominoforever, please visit our Destination Domino Page

Status Shipped
Workspace Domino Designer
Categories Views
Created by Guest
Created on Jan 28, 2020

How to make a View with 50 000 or more docs

How to make a View with 50 000 or more docs/records in Db, showing only the persons docs, based on the "readeronly" field for 10 000 users or more. No re-indexing problem when index is ready!

You must have a form with your selected info fields. It must include a visible readerfield for examples called ReaderNamesList, and for safety and for update all docs for admin, an author field with default value of the ACLs admin Role, example: [AdmRole].


Make a View that select form over, and with the first column, as hidden, and a formula as follows:
@Name( [Abbreviate]; @Subset( ReaderNamesList; 1 ) )

Make some more columns with values from field on form.

It must have ticked off, "Ascending", "Categorized" "Show multiple ....", "Hidden" in the Column prop.

View prop should have refresh "Automatic",

Then make a Page, with an embedded View created over with the formula "@Name([Abbreviate];@UserName) " in Show Single Category

Easy you can launch the page on the dBs prop on open, and voila: you have a personalized view, showing only the personal selected docs in the view, based on an already refreshed view.

If you have an integration with relational dB and populate the db. from there, it is important that you populate and write to the readerfield with the correct value.

  • Attach files
  • Guest
    Jan 28, 2020

    Yes, this is based on existing functions, but the combination  of the functions are new for most people, and solves a Lotus View problem that many have addressed. 

  • Admin
    Thomas Hampel
    Jan 28, 2020

    It seems like this is a description for an existing function. This is not an idea. So closing with 'already exists'