View Selection Help (domino designer)

105 pts.
Tags:
Domino 6.5
Domino Designer
Lotus Domino
Lotus Domino 6.5
Lotus Domino development
View Selection
I have a Status field that if it equals 90 and it means that it is closed and has a date of when it was closed. If it equals 80 it is open.. 70 it is void ... and so on down to 10. So I want to display all everything except the old ones which Status = 90 doesn't have a close date and is blank. If I put @Isavailable(DateS90) it only displays the the status = 90 with dates in them and takes away the 80,70,60,50,40,30,20, and 10. I want to display all those as well just not the status = 90 that are blank. DateS90 = it eqauls the close date. So any Ideas

Software/Hardware used:
Domino 7.0
ASKED: October 5, 2010  7:51 PM
UPDATED: October 6, 2010  1:29 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

It sounds like you want to exclude all documents that have a status of 90 and a blank closed date. The best way to do this is write a formula to show only those documents, then reverse the logic by placing it in a NOT expression.

To show only those documents:

SELECT Status = 90 & DateS90 = “”

To show all documents that do not meet that condition:

SELECT !(Status = 90 & DateS90 = “”)

This will work in all versions of Notes.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following