View Selection Help (domino designer)
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
Software/Hardware used:
Domino 7.0
ASKED:
October 5, 2010 7:51 PM
UPDATED:
October 6, 2010 1:29 PM
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
