Search code examples
javaxpageslotus-notes

documents not appearing in a view

I have created Notes documents by script and I want them to appear in a view.

I have the following selection formula for the view:

SELECT Form="formA" & status="X" & keyField = ""

If I check the view the documents do not appear in them. If I check the documents with help of ScanEZ, DocumentViewer or the Document properties box the documents match the criteria:

  • they docs have these fields
  • these fields have the correct values

if I change the selection formula to:

SELECT Form="formA" & status="X" & keyField != "SOMESTUPIDVALUE"

the documents appear in the view.

Note these docs are created by JAVA code and never opened in a Notes client.

Anyone have an explanation for this behavior?

Solution

  • Have you got summary tags on those fields? Set issummary on the note items