~Mary ChuabergFeb 2, 2016, 8:59 PM82 Postssome infoIf the database is full text indexed, try something like this: Dim session As New NotesSession,db As NotesDatabase,coll As NotesDocumentCollection Dim query As String, anyString As string Set db = session.Currentdatabase anyString = "lwp" query = |[Form] = "Memo" and [Body]{| + anyString + |}| Set coll = db.Ftsearch(query, 0) Print "the number of docs is: " + CStr(coll.count) If the database is NOT full text indexed, I think the problem you are having is that Body is a RichText field and the query selection does not like rich text. Simply try create a view with: Select Form = "Memo" & @Contains(Body ; "Normal Engineering work hours") Does it return docs? If not, it gets a little more complicated. Let me know.
~Sigmund UmwemanoniFeb 3, 2016, 2:26 PM323 PostsIf you can do what Bob says, great! That's way faster. If not ...... take a look at @Abstract([TEXTONLY]; 64994; ""; "Body") to retrieve some of the Body field. Also, you may want @Uppercase() if the string check shouldn't be case sensitive.
~Joseph BrenitexjipFeb 4, 2016, 7:45 PM21 PoststhanksThank you gentlemen.. I'll give a go in a few hours...