View selection not working

HCL Domino Domino Forum
1

I have a database of scanned documents and a view with a simple View selection = “field Type contains FS”

It displays some records and not others where that condition is satisfied. My users are concerned that their documents are “disappearing”. Why might this be?

I have checked a doc missing from the view and the field “Type” contains just the text “FS”. Baffled.

I have run Fixup - no joy. Any ideas?

2

Subject: RE: View selection not working

This type of view selection is rarely used, and I’m not sure how it works. I think it uses the full-text index of your database. Do you have one? Might it be corrupt? Try deleting and re-creating it. Or, use a formula for selection instead.

3

Subject: RE: View selection not working

Ah well - we use it coz it is simple and there isn’t anything to go wrong!. yet it has :frowning:

deleting and re-creating the index made no difference

4

Subject: RE: View selection not working

Simply change the view’s selection to a formula:

SELECT @Contains(Type; “FS”)

or

SELECT Type=“FS”

Use the first if you want to include any documents where the string “FS” appears as any part of the Type field; use the second for exact matches.

5

Subject: RE: View selection not working

Interesting - if you switch from “simple search” to “formula” - it creates more or less the formula you suggested automatically. And it then works.

???

looks like a serious limitation of simple searches (aka “bug” I guess).

thanks everybody