CODEWITHSUNDEEP
javaxpageslotus-notes
Patrick Kwinten
Patrick Kwinten

Reputation: 2048

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:

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?

Upvotes: 1

Views: 127

Answers (3)

rakesh
rakesh

Reputation: 338

Could be that the view setting "Show response documents in a hierarchy" is set and the document you are creating is a response document. If this setting is true, response docs would only appear if parent document is also part of the selection.

Solution would be to also show parent docs or remove the $REF fields.

Upvotes: 0

Adam Foster
Adam Foster

Reputation: 88

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

Upvotes: 3

Richard Schwartz
Richard Schwartz

Reputation: 14628

A bit of a guess, but I think you'll find that your Java code is setting the value of keyField to a single space character (" ") instead of an empty string "". Try changing your selection formula to this:

SELECT Form="formA" & status="X" & @Trim(keyField) = ""

If that works, you can fix your Java code to eliminate the unwanted space between the quotes, and the selection formula will still work for both your existing documents and for documents created after the fix.

Upvotes: 0

Related Questions