Function EN Version 4.50

@BuildNamedDocKeyLists

Database Float IDList List Misc NUMBER Search TimeDate

Syntax

@BuildNamedDocKeyLists(DBHANDLE;FORMULAGROUPDOCS;FORMULAPERSDOCS;TDSINCE;NOTECLASSES;NAMEFIELDNAMEGROUPDOCS;NAMEFIELDNAMEPERSDOCS;FNFLAGS;RETHTL;RETIDL);

Description

This @Function creates two corresponding lists (HUGETEXT RETHTL and IDLIST RETIDL). In the list HUGETEXT RETHTL the contents of the fields are returned sorted alphabetically, from the documents specified by the selection formulas TEXT FORMULAGROUPDOCS and TEXT FORMULAPERSDOCS as well as by TD TDSINCE and FN NOTECLASSES specified documents of the DB with the DBHANDLE DBHANDLE, is returned. Correspondingly, in the list IDLIST RETIDL the NOTEIDs of the documents are returned.

TEXT FORMULAGROUPDOCS:
For the documents specified by these selection formulas, it is assumed that the contents of the field named TEXT NAMEFIELDNAMEGROUPDOCS in den Dokumenten vom Datentyp TEXT oder TEXTLIST, and are group names or persons from the Notes address book.
Groups are expanded (the group must be defined as type Mail or Multipurpose in the Notes address book), and the result is entered as individual names in the list HUGETEXT RETHTL entered.
If a name is present in several groups, only the information (NOTEID at the corresponding position in IDLIST RETIDL) des ersten Auftrettens entered.
If TEXT FORMULAGROUPDOCS is specified as a NULLSTRING (""), this step is skipped.

TEXT FORMULAPERSDOCS:
For the documents specified by these selection formulas, it is assumed that the contents of the field named TEXT NAMEFIELDNAMEPERSDOCS in den Dokumenten vom Datentyp TEXT oder TEXTLIST are.
The contents are entered as individual names in the list HUGETEXT RETHTL entered.
If a name already exists, only the information (NOTEID at the corresponding position in IDLIST RETIDL) des letzten Auftrettens entered.
If TEXT FORMULAPERSDOCS is specified as a NULLSTRING (""), this step is skipped.

TD TDSINCE:
Only the documents in the lists that were created before the time specified in TD TDSINCE are considered. If the documents are to be considered regardless of their creation time, the @Function @AnyAllDay den passenden Zeit-Datums-Wert (siehe @AnyDay/@AllDay/@AnyAllDay).

FN NOTECLASSES:
This parameter specifies which classes of documents are to be considered.
DEC   BIT   Bedeutung

00000   XX   No Notes   no documents
00001   01   Documents   Daten-Dokumente
00002   02   Policy-Note   profile database document
00004   03   Form-Note   Masken-Design-Dokumente
00008   04   View-Note   Ansicht-Design-Dokumente
00016   05   Icon-Note   Piktogramm-Dokument
00032   06   Design-Collection-Note   Ansicht-Dokumente
00064   07   ACL-Info-Note   ACL-Info-Dokument
00128   08   Help-Index-Note   
00256   09   Help-Note   Hilfe-DB-Dokument
00512   10   Filter-Note   Macro-Design-Dokumente
01024   11   Feld-Note   Feld-Design-Dokumente
02048   12   Replication-Note   Replikations-Dokumente
04096   13   Privat_Design   Privat-Design-Dokumente

32768   16   Default-Note of Each   the default document of each

32767   01-15   Notes   Alle Dokumente
32766   02-15   All Non-Document-Notes   all non-data documents

(To specify multiple document classes, the values of the respective classes are added or built using @BitVektor aufgebaut)

TEXT NAMEFIELDNAMEGROUPDOCS:
This parameter specifies the name of the fields in the documents specified by TEXT FORMULAGROUPDOCS . The contents of these fields (Datentyp TEXT oder TEXTLIST) are interpreted as group names or persons from the Notes address book (the groups are expanded) and entered individually in the returned lists.

TEXT NAMEFIELDNAMEPERSDOCS:
This parameter specifies the name of the fields in the documents specified by TEXT FORMULAPERSDOCS . The contents of these fields (Datentyp TEXT oder TEXTLIST) are entered individually in the returned lists.

FN FNFLAGS:
0   Keine Flags
1   Abbreviate All names are converted to abbreviated form where possible.
2   Canonicalize All names are converted to canonical form where possible.

As a return value, the @Function returns on error @ERROR otherwise TRUE.

Example: @BuildNamedDocKeyLists(DBHANDLE;FORMULAGROUPDOCS;FORMULAPERSDOCS;TDSINCE;NOTECLASSES;NAMEFIELDNAMEGROUPDOCS;NAMEFIELDNAMEPERSDOCS;FNFLAGS;RETHTL;RETIDL);

DBHANDLE:=@OpenDB("names.nsf");
FORMULAGROUPDOCS:="SELECT Form=\"Group\"";
FORMULAPERSDOCS:="SELECT Form=\"Person\"";
TDSINCE:=@AnyAllDay;
NOTECLASSES:=1;
NAMEFIELDNAMEGROUPDOCS:="ListName";
NAMEFIELDNAMEPERSDOCS:="FullName";
FNFLAGS:=1;
RET:=@BuildNamedDocKeyLists(DBHANDLE;FORMULAGROUPDOCS;FORMULAPERSDOCS;TDSINCE;NOTECLASSES;NAMEFIELDNAMEGROUPDOCS;NAMEFIELDNAMEPERSDOCS;FNFLAGS;RETHTL;RETIDL);
@LogReport(RET);
n1:=1;
n1e:=@Elements(RETHTL);
@LogReport("Elemente:"+@Text(n1e));
WHILE(n1<=n1e)
{
   Name:=@GetListElement(RETHTL;n1);
   ID:=@GetListElement(RETIDL;n1);
   @LogReport("Name:"+Name+" NoteID:"+@Text(ID));
   @Increment(n1);
}
DBHANDLE:=@CloseDB(DBHANDLE);

In this example, a list with the names of all persons entered in the address book (sorted alphabetically) is built and in RETHTL is returned. Groups are expanded to their members where possible. If a name is only present in one or more groups then in the corresponding list RETIDL at the same position the NoteID of the first occurrence in a group is stored. If a person document also exists for a person the NoteID of this document is (at the corresponding position) in the list RETIDL abgelegt.
The names are entered in abbreviated form, where possible, in the list RETHTL entered.

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