Function EN Version 10.02

@FindDocumentsByKey

View

Syntax

@FindDocumentsByKey(VIEWHANDLE1;NAME2);

Description

Searches in the view with the VIEWHANDLE VIEWHANDLE1 the category(n) with the name TEXT/TEXTLIST NAME2 and liefert a VIEWPOS on success.
If NAME2 is a TEXTLIST, the elements for einander is searched for in the sorted columns.
Example:
A view with three sorted columns, name, Ort, Str (there may also be additional unsorted columns between these columns).
NAME2:="Meier":"Mainz":"Hauptstr";
So is only in the column name for "Meier" searched for, then in the column Ort for "Mainz" and finally in the column Str for "Hauptstr".
On success, a VIEWPOS for the first document that meets these conditions is returned.

Example: @FindDocumentsByKey(VIEWHANDLE1;NAME2);

DBHANDLE:=@OpenDB("TEST.NSF");
VIEWHANDLE1:=@OpenView(DBHANDLE;"TEST VIEW");
NAME2:="EINS";
VIEWPOS:=@FindDocumentsByKey(VIEWHANDLE1;NAME2);
VIEWHANDLE1:=@CloseView(VIEWHANDLE1);
DBHANDLE:=@CloseDB(DBHANDLE);

The database with NotesPath "TEST.NSF" and the view named "TEST VIEW" are opened, the key "EINS" in the view "TEST VIEW" is searched for, and the VIEWPOS of the first document output.
Finally, the database and the view are closed again.

Note : This text was machine-translated and may contain inaccuracies.