Function EN Version 5.00

@ReplicateWithFormulaWithFieldException

Database NotesAdmin NotesSystem Replication

Syntax

@ReplicateWithFormulaWithFieldException(DBHANDLE1;DBHANDLE2;FORMULA3;FNLIST4;FIELDNAMELIST1;FIELDNAMELIST2);
@ReplicateWithFormulaWithFieldException(DBHANDLE1;DBHANDLE2;FORMULA3;FNLIST4;FIELDNAMELIST1;FIELDNAMELIST2;NOTECLASSES5;FNREPLICATIONFLAGS6);
@ReplicateWithFormulaWithFieldException(DBHANDLE1;DBHANDLE2;FORMULA3;FNLIST4;FIELDNAMELIST1;FIELDNAMELIST2;NOTECLASSES5;FNREPLICATIONFLAGS6;FNLISTERROR7);

Description

Replicates the database with DBHANDLE DBHANDLE1 with the database with DBHANDLE DBHANDLE2, replicating only the documents thas match the Notes-compatible selection formula TEXT FORMULA3 entsprechen. FNLIST FNLIST4 is a list of rights where the first element specifies the replication rights in the first database and the second element specifies the rights in the second database. The databases do not have to be replicas of each other. FN FNREPLICATIONFLAGS6 can be used to enable or disable options in the replicator.

TEXT/TEXTLIST FIELDNAMELIST1:
Specifies a TEXT/TEXTLIST containing the names of the fields thas should be preserved in the documents in DB1.
(Fields with the same name contained in documents from DB2 are deleted from documents thas arrive in DB1.)
TEXT/TEXTLIST FIELDNAMELIST2:
Specifies a TEXT/TEXTLIST containing the names of the fields thas should be preserved in the documents in DB2.
(Fields with the same name contained in documents from DB1 are deleted from documents thas arrive in DB2.)

A FNLIST is returned:

element   Meaning
1   UpdateCount DBHANDLE1
2   CreateCount DBHANDLE1
3   DeleteCount DBHANDLE1
4   UpdateCount DBHANDLE2
5   CreateCount DBHANDLE2
6   DeleteCount DBHANDLE2

FNLIST4:

Bit   HEX   Meaning
01   0001   Read
02   0002   Write
03   0004   Modify
04   0008   Delete

The optional parameter NOTECLASSES NOTECLASSES5 is used to restrict the documents considered in the selection formula TEXT FORMULA3. If parameter 5 is not specified, the selection formula TEXT FORMULA3 is applied to documents of NOTECLASS 1 (Documents).

NOTECLASSES5:
DEC   BIT   Meaning

00000   XX   No Notes   no documents
00001   01   Documents   data documents
00002   02   Policy-Note   About database document
00004   03   Form-Note   form design documents
00008   04   View-Note   view design documents
00016   05   Icon-Note   icon document
00032   06   Design-Collection-Note   view documents
00064   07   ACL-Info-Note   ACL info document
00128   08   Help-Index-Note   
00256   09   Help-Note   help database document
00512   10   Filter-Note   macro design documents
01024   11   field-Note   field design documents
02048   12   Replication-Note   replication documents
04096   13   Privat_Design   private design documents

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

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

(To specify multiple document classes, add the values of the relevant classes or build them using @BitVektor.)

FNREPLICATIONFLAGS6:

Bit   HEX   Meaning
01   0001   Localize links (Doc;View;DB) in databases with different replica IDs.

FNLISTERROR7:
When the optional return parameter FNLISTERROR7 is used, error statisics are returned in it.

element   Meaning
1   Error UpdateCount DBHANDLE1
2   Error CreateCount DBHANDLE1
3   Error DeleteCount DBHANDLE1
4   Error UpdateCount DBHANDLE2
5   Error CreateCount DBHANDLE2
6   Error DeleteCount DBHANDLE2

Example: @ReplicateWithFormulaWithFieldException(DBHANDLE1;DBHANDLE2;FORMULA3;FNLIST4;FIELDNAMELIST1;FIELDNAMELIST2)

DBHANDLE1:=@OpenDB("TESTRP1.NSF");
DBHANDLE2:=@OpenDB("TESTRP2.NSF");
FORMULA3:="SELECT Form=\"TEST FORM\"";
FNLIST4:=@BitVektor(1:2:3:4);
FNLIST4:=FNLIST4:FNLIST4;
FIELDNAMELIST1:="TestfieldInDB1";
FIELDNAMELIST2:="";
@LogReport(@ReplicateWithFormulaWithFieldException(DBHANDLE1;DBHANDLE2;FORMULA3;FNLIST4;FIELDNAMELIST1;FIELDNAMELIST2));
DBHANDLE2:=@CloseDB(DBHANDLE2);
DBHANDLE1:=@CloseDB(DBHANDLE1);

The database "TESTRP1.NSF" with the database "TESTRP2.NSF" is replicated and the result is output. Only documents matching the selection formula are replicated.
The fields, or the field contents, with the name "TestfieldInDB1", are preserved in the documents of DB "TESTRP1.NSF" are preserved.

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