Problem Select Embedded View

I have a problem with Embedded view and just select. i have this view whith this selection:SELECT Form = “Ordine” & Status = “1”

in this view i can see all documents that have field Status=1 but sometimes in this view i can see document with field status <> 1 . i don t know after if i open view and i add character to begin of row and refreh i don t see fake documents (<> 1). Why???.. is a problem of refresh? cache?

Subject: Problem Select Embedded View

I’m not too knowledgable in notes, but are you sure that the field type on the form is text? if it’s a number, then you should type status=1 (without quotes) in the view, and if text, then status=“1”

Since when you append something it works ok, I don’t think it’s a cache issue.

Subject: RE: Problem Select Embedded View

yes… field status is text

Subject: RE: Problem Select Embedded View

Did you use ‘Simple Search’ in the ‘View Selection’ of the view? If no, try it, instead of using ‘select…’. Click the ‘Add condition’ button and add both two conditions, making sure it is ‘and’ nor ‘or’.

Subject: RE: Problem Select Embedded View

i have used formula in embedded view and my formula is SELECT Form = “Ordine” & Status = “1” now i try use simple search… after i will say u… thank u