Hi,
I want to get a list of all the certifiers from the Certificates view of names.nsf database using the @GetField formula.
Following is the formula that I have been able to form but it is always returning a count of 0 and there are certifiers availabe for the same:
userDB.search(“@GetField(form = "Certificates")&(CertificateType=0)”);
Please help me in getting the correct formula.
Subject: @GetField is not suitable for this
I can see you are attempting to use a Search method using LotusScript. So I suggest you to look at this algoritm instead (syntax not validated 100%):
Dim db As New NotesDatabase( “”, “names.nsf” )
Dim session As New NotesSession
Dim view As NotesView
Dim doc as NotesDocument
Set view = db.GetView(“($CrossCertByRoot)”)
Set doc = view.GetFirstDocument
While Not ( doc Is Nothing )
If doc.CertificateType(0) = “0” Then
msgbox "Found one of Type = 0 !" & doc.IssuedBy(0)
End If
Set doc = view.GetNextDocument( doc )
Wend
I hope you can fill in the blanks here and there.
Regards