View Selection - Formula help with SELECT statement

HCL Domino Domino Forum
1

I’m having problems with the SELECT statement used to select documents within the View Selection.

The follow code does not work(1st attempt):

one = “Open”

two = “Closed”

formula = |SELECT IssueStatus = [| & one & |] & IssueStatus = [| & two & |]|

I’ve also tried the following

The follow code does not work(2nd attempt):

formula = |SELECT IssueStatus = “Open” & IssueStatus = “Closed”|

Error from above code:

Notes error: Unknown [KeyWord] for @Function (SELECT IssueStatus = [Open]&IssuesStatus = [Closed]

What I am trying to do is to select all documents that have either ‘Open’ or ‘Closed’ status. Can anybody help please?

Thanks in advance!

2

Subject: View Selection - Formula help with SELECT statement

Maybe your problem is the AND (&) where it should be an OR (|) and your syntax.

eg - if its a view selection formula - SELECT IssueStatus = “Open”:“Closed”

or you could use

SELECT IssueStatus = “Open” | IssueStatus = “Closed”

3

Subject: RE: View Selection - Formula help with SELECT statement

Scratch

4

Subject: View Selection - Formula help with SELECT statement

Select IssueStatus = “Open”:“Closed”