CODEWITHSUNDEEP
lotus-dominolotus-formula
AJF
AJF

Reputation: 1921

Filter View on Empty Field

I have a Notes Domino application where I am trying to create a View which lists documents which are filtered on a particular field being empty. I have the View created with the required fields and the field I am attempting to filter on I have set as a formula of @IsNull(FileCompletedDate) but the view is not returning anything. What is the correct method to perform this please.

enter image description here

Upvotes: 2

Views: 1184

Answers (1)

Knut Herrmann
Knut Herrmann

Reputation: 30960

Put 

SELECT @IsNull(FileCompletedDate)

or 

SELECT FileCompletedDate = ""

into View Selection formula.

You put your formula into Column formula. It defines the content of a column but has no effect on document selection.

Upvotes: 2

Related Questions