Clever Geek Handbook

Received Lotus Notes mail

I am using lotus notes 8.5.2 on windows 7. I would like to create a custom view that displays all EXCEPT emails sent by mail. In other words, it contains: INBOX and ALL FOLDERS.

Currently my ALL DOCUMENTS view has the following formula conditions: SELECT @IsNotMember("A"; ExcludeFromView) & IsMailStationery != 1 & Form != "Group" & Form != "Person"

The SENT view has the following conditions: SELECT DeliveredDate = "" & PostedDate != "" & !(@IsMember("S"; ExcludeFromView))

My thinking is that I should be able to exclude the SENT conditions from the ALL DOCUMENT?

Thank you so much

+3


source to share


1 answer


Taking all documents that are not in the Sent view is not entirely correct, because there are several documents that are not in the Sent view that are also excluded from the All Documents view. Logical logic:

SELECT (in the All Documents view) AND NOT (in the Sent view)

So, first make a copy of all documents. You want to keep the selection formula from the All Documents view and put it and () after it, for example:



SELECT ( @IsNotMember("A"; ExcludeFromView) & IsMailStationery != 1 & Form != "Group" & Form != "Person" ) & !( )

Now, just copy the selection formula from the Sent view and put it between those blanks, so the result is as follows:

SELECT ( @IsNotMember("A"; ExcludeFromView) & IsMailStationery != 1 & Form != "Group" & Form != "Person" ) & !( DeliveredDate = "" & PostedDate != "" & !(@IsMember("S"; ExcludeFromView)) )
+4


source






More articles:


All Articles