Maximums in Notes

What is the maximum size of a database?
The maximum OS file size limit (up to 64GB)
What is the maximum size of text fields?
32KB (storage); 32KB displayed in a view's column
What is the maximum size of a rich text field?
Limited only by available disk space up to 1GB
What is the maximum size of a single paragraph in a rich text field?
64KB
What is the maximum amount of Text (Summary) data per document?
64KB
How many levels of responses in a hierarchical view; how many documents at each level?
31 levels; 300,000 documents
How many columns can be included in one table?
64
How many rows can be included in one table?
255
How many views can be added to a database?
No limit; however, as the number of views increases, the length of time to display other views also increases
How many columns are allowed in a view?
289 ten-character columns; dependent upon # or characters per column
How many documents can be imported into a view?
Documents totaling at least 350K
How many cascading views are allowed in a database?
200
What is the maximum value (in inches) you can enter for margin size?
22.75
What is the maximum value (in inches) you can enter for page size cropping?
46
What is the maximum point size you can select/print?
250
How many documents are allowed in one view?
Maximum of 130MB for a view index
What is the maximum number of documents that can be exported to Tabular Text?
Limited only by available disk space
What is the maximum number of entries in an Access Control List?
~950 names (total ACL size is limited to 32767 bytes)
What is the maximum number of roles in an Access Control List?
75 Roles
What's the maximum password length allowed on an ID?
64 bytes (63 characters for single-byte character sets but only 21 characters for some double-byte languages)
What is the maximum number of contacts allowed in a group in the Personal Address Book?
32K of names in the Members text field
What is the maximum number of recipients in a single mail message?
For individual names and private groups which expand locally, 15KB; for public groups which expand on a server, 5MB 64
How many rows can be included in one table?
255
How many views can be added to a database?
No limit; however, as the number of views increases, the length of time to display other views also increases
How many columns are allowed in a view?
289 ten-character columns; dependent upon # or characters per column
How many documents can be imported into a view?
Documents totaling at least 350K
How many cascading views are allowed in a database?
200
What is the maximum value (in inches) you can enter for margin size?
22.75
What is the maximum value (in inches) you can enter for page size cropping?
46
What is the maximum point size you can select/print?
250
How many documents are allowed in one view?
Maximum of 130MB for a view index
What is the maximum number of documents that can be exported to Tabular Text?
Limited only by available disk space
What is the maximum number of entries in an Access Control List?
~950 names (total ACL size is limited to 32767 bytes)
What is the maximum number of roles in an Access Control List?
75 Roles
What's the maximum password length allowed on an ID?
64 bytes (63 characters for single-byte character sets but only 21 characters for some double-byte languages)
What is the maximum number of contacts allowed in a group in the Personal Address Book?
32K of names in the Members text field
What is the maximum number of recipients in a single mail message?
For individual names and private groups which expand locally, 15KB; for public groups which expand on a server, 5MB

Reseting values of Fields created by LS using Lotus Script

I had a field in a document called 'ISPENDINGREVISION'. I wanted to change the value of this field to 0 using an agent which would run on selected documents in a view.

I tried with the following code:

@SetField("ISPENDINGREVISION";0)
and then
FIELD ISPENDINGREVISION:=0....

but both didnt work.

Then i realised this field is getting created from the background using Lotus Script. so used the following code and it worked

FIELD ISPENDINGREVISION:=@DeleteField;
FIELD ISPENDINGREVISION:=0;

Db Copy did not contain all elements of it original....Why?

Recently I faced this problem which was kind of unique for me. Something probably most of you would have faced. Since my aim in this whole initiative was to maintain a memoir of all the peculiar behaviors observed during the course of my professional life, no matter how lame it might seem so I decided to put it on paper.

I have a database, on which I have Manager Access through a group. I wanted a copy of the database on the local. So I added my name explicitly in ACL with Manager Access and created a copy of the database.

I opened the local copy and clicked on a particular outline entry, it threw an error 'Invalid or nonexistent document'. In the original database, this would open a view.

The error is generally thrown when a particular view by that name doesn't exist in the database. To my surprise I found that the view in the question was not found in the database. A little more investigation and brainstorming with my colleagues revealed the reason behind it. The view had a security constraint. In the Security tab of the view, the check box for 'Who may use this view' was unchecked and a few roles had the checks against it, which means that only people with the specified roles can read or see or use this view. I applied the same roles to my ACL entry in the original database and then created a copy. I could see these views copied in the new copy.

 

So, next time when u find that your copy of database doesn't have few design elements, please look for the security settings.