Looking for ideas on problem with view

HCL Domino Domino Forum
1

I have a lotuscript that is attempting to set a view in preparationfor ftsearch - I know the view has entries but when I set the view object in my agent, I get ALLENTRIES = 0. The code is below - any suggestions on what I can look for that may be causing this problem?

NOTE: after the code below, CTPAview.TOPLEVELENTRIES = 2 (which is the # of entries I see when I goto the view from Notes Client) but CTPAviewe.ALLENTRIES = 0.

Thanks

’ db as already been defined and created

Dim CTPAview As notesview

Set CTPAview = db.GetView( “All CTPAssignments by Key flat” )

CLARIFICATION: I am looking at ALLENTRIES because the following FTSEARCH always returns 0 documents even though I knew the query value is in the viewed documents. My diagnosis turned up that the view has ALLENTRIES = 0.

2

Subject: Just to clarify

Are you using CTPAview.TopLevelEntryCount and CTPAview.AllEntries.Count ?

I ask because AllEntries is a NotesViewEntryCollection, and TopLevelEntries doesn’t exist in LotusScript.

Phil

3

Subject: Not using either

Good question - I only mentioned AllEntries and TopLevelEntries because I examined them as part of my diagnosis. This resulted from my diagnosing why an FTSearch was returning 0 documents when I knew there should be documents returned from the search - what I found was that AllEntries was 0 when it should be 2.

4

Subject: FT Index corrupted/not updated?

Since you are saying that a FTsearch() is not returning documents you know are in the database, if I were you I would start looking at the full text index. 1) How often is it set to update?

  1. Is it up-to-date when you test your code (“all documents indexed”)?

  2. If it is set to “immediatly” and is up-to-date, I would delete the index (both deleting it from within Notes and physically in the file system on the server by removing the .FT directory. Then recreate the full text index and try again.