I wish to omit deleted documents from a view using @formula.
Any way ?
Thx
Alex
Subject: Have you checked the help file?
You can find the answer in less time that it takes to type that question…
Subject: RE: Have you checked the help file?
I did and found @nothing 
Subject: Sorry for my snarkiness, but…
Go to the Index of the Designer help and type “Delete”, which should make the @DeleteDocument function appear. While it is not the correct function for deleting from a view, it tells you the correct one - @Command ([EditClear])
Do you see why I wondered whether you’d looked? I’m guessing you just didn’t check the index. Wading through the table of contents would make it slightly harder to find.
Subject: RE: Sorry for my snarkiness, but…
Thy, but you might have overlooked my question …Or it may be I was not clear (I am really new to domino).
What I need is " …to omit deleted documents from a view using @formula".
I have documents that are marked as deleted but still in the views with a mark. They are removed from the database when I refresh the view or close database (and answer YES to the prompt.
I just want to omit the deleted-marked documents from the view. Something like SELECT !@IsDeleted
I looked in the help but !@found … lol
Alex
Subject: !@found also
Ah, now it makes sense.
No, I don’t think there is such a function in Notes. The documents are only marked for deletion until you do one of those things.
I think the querydocumentdelete subroutine in the database script might allow you to change the behaviour of the database to refresh whenever someone deletes something, but I could be wrong about when it triggers.