View selection

HCL Domino Domino Forum
1

I’m having dificulty getting the selection of documents that I want.I’ve got this formula:

SELECT (Form = “Property Card”) & (@Contains(status; “Given Notice”)) & (!@Contains(archive; “Archive”))

I also want documents with the status of “Vacant”

I can’t seem to get an Or to work in the (@Contains(status; “Given Notice”)) section.

I’m looking for:

Form=Property Card

and

status=Given Notice or Vacant

and

archive=Archive

thanks in advance for your time

Jim

2

Subject: View selection

This is exactly why I use this method:

It sometimes requires a change in methodology from a development standpoint, but it’s proven extremely useful time and time again. I get the documents I want to display in the views that I want, and it’s controlled by logic at the document-level.

HTH,

-Chris

Chris Toohey

3

Subject: View selection

Jim, I don’t have data in front of me to confirm this is correct, but I think this will work.

SELECT Form = “Property Card” & (Status = “Given Notice” | Status = “Vacant”) & Archive != “Archive”

values in quotes are case sensitive.

Stephen

4

Subject: RE: View selection

Or the simpler form, comparing Status to a list …(I also like to break lines for readability)

SELECT

Form = “Property Card”

& Status = “Given Notice”:“Vacant”

& Archive != “Archive”