Lotus BS develops notes

zhaozj2021-02-16  36

Find the user's unit and department according to the current user name in the organizational unit library.

Reference: User Information Form Sys_User

User belongs to TXT_BELONGTOUNIT

Users belong to TXT_BELONGTODEPARTMENT

(For other libraries) view (alluser)

REM {According to the current user's name, the representative of the document is located.

Server: = @ Name ([CN]; @ Subset (@dbname; 1));

Path: = @ leftback (@SUBSET (@dbname; -1); "//");

DBNAME: = "SYS_ORG.NSF";

DBPATH: = PATH "//" DBNAME;

VIEWNAME: = "(alluser);

Username: = @name ([CN]; @ username);

FieldName: = "txt_belongtounit";

@Dblookup ("": "Nocache"; Server: dbpath; viewname; username; FieldName)

annotation:

The value of Server is empty. DBNAME, VIEWNAME, FIELDNAME is assigned according to different situations.

The view shows the addition of HTML control issues.

The first column of the view is classified and ranked sequence. Other lists are sequences.

If you need to add a check box in front of the view entry. Insert a list of new columns in front, title is " & NBSP ". The column formula is: " ".

A "blank" column is coupled between the first column classification column and the checkbox column. The title is not. The column formula is: " ".

Be sure to note: The "Merge Classification Information" option in the sort of the classification column property box is not selected.

If there is a multi-value domain in other columns as a column formula, the column property box should be selected "Separate a multi-value to independent row" and will be sorted. Only one of the two items cannot be displayed correctly.

If you do not need a checkbox, this column "blank" column is added to the back of the first column classification column, the second column. And to add a column in front, the title and formula are: ""

Implement the function of private views on the Web

Features of a private view is that the view only shows the document entry with the current user. Therefore, it can be envisioned that the relevant view is designed to classify according to the username and then embed in the form. Add a text domain on the head of the form, the role of this domain is to record the current username. The embedded view only shows a single category.

Add a text editing box in a form of embedded view

In a form named at the beginning of $$ viewTemplate for, add a text editing box, but if it is a form of a specific name $$ viewTemplatedEfault, only text form is displayed on the web page (it seems The calculation text domain is changed, and the edit box will appear.

The form named $$ ViewTemplatedEfault is not identical to the JavaScript generated by the server when generating a web page is different from the form named $ VIEWTEMPLATE for VIEWNAME. Therefore, it is not possible to operate (submit) operation. Use of each object in the web page

If there is only one instance of a similar object in a web page, you cannot read the array. If there are multiple, you can.