Search for null in rich-text field

HCL Domino Domino Forum
1

I’m trying to use a not-null value in a view, but the field is a rich-text field and everything I’ve tried seems to only work on a plan text field, but not rich-text. Is there a way to do this?

I want a view that will, for example, display forms that have something in the field OpenPMRs

I’ve tried the following (which all work on regular text field, but not rich-text):

OpenPMRs != “”

@isnull(OpenPMRs) !=1

@getfield(OpenPMRs) != “”

Thanks!

Elizabeth

2

Subject: Search for null in rich-text field

You can’t refer to rich text fields directly. Put a computed text field in the form using @Abstract on the rich text field. You’ll be able to use the contents of that field in your view. (Don’t, by the way, try using @Abstract on the rich text field in view columns or selection formulas. It to be in the document.)