Has anyone experienced db.Search() results that contain profile documents, when they shouldn’t? This is my LotusScript …
searchFormula$ = “(Form = ““ViewContentDoc”” | Form = ““ContentDoc””) & Package = “”” & pkg & “”" & Status = ““PENDING”” & Country = “”" & ctry & “”“”
Set col = db.Search(searchFormula$, Nothing, 0)
I would expect 1 document returned in the collection, but I get 14 (the extra 13 are profile documents).
I copied my database (design & docs) from an R5 Server to an R6 server. The LotusScript code is in a script library that gets invoked from an agent which is called from a view action button. I am running R5.0.11
Subject: db.Search results include profile docs, but shouldn’t - This seems to be a major BUG
I’m experiencing the same thing, however I tried to create a replica of the database to be searched on an R5 server and everything worked fine (on the R6 it didn’t).
It seems to differences in the ODS format that cause these problems: 41:0 worked fine 43:0 did not.
Just like you I´m using an R5 client (R5.0.12)
However, if the database being searched is opened UI in the R5 client everything works fine, eventhough the database is on an R6 server.
If what we both are experiencing is in fact a bug, then it’s simply terrible that Lotus/IBM can release a product where R5 clients cannot search databases on an R6 server.
Subject: db.Search results include profile docs, but shouldn’t
One question. What client OS is your Notes client running on? We are having similar issues have noted that on WIN2K/98/95/NT client machines are NOT having this problem; however, on XP machines, the problem occurs.