Search code examples
lotus-dominolotus-formula

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

Solution

  • 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.