@Today View in the Reservations DB in Domino 6

HCL Domino Domino Forum
1

OK. I have been trying this for a while with no success. I have created a Today view in the Resource Reservations DB by specifying @Today as part of the view selection.

This works fine, however if there is a recurring meeting, it will show up all the Meeting times for that meeting. This has to do with Response Documents being used. How would you get rid of all the response documents execpt the one for that particular day?

Thanks

Steve

2

Subject: @Today View in the Reservations DB in Domino 6

Since you have @Today in your SELECT, you only see responses that contain the correct meeting.Remember: repeating entries are initially stored in 1 document. Only when you start to modify them, they are split into multiple responses.

So, you need to make sure there is no reason for the view to display the other repeats in the same document: don’t use a column that shows the repeat list of that response.

3

Subject: RE: @Today View in the Reservations DB in Domino 6

It is a very bad idea to use @Today in a view selection formula. A better idea would be to create an agent to run shortly after midnight that would update a “flag” on the documents which would specify if that document was valid for the current day, and key off of that in the view selection formula.

4

Subject: yep, yep, yep

@Today, @Now and the like cause the view’s index to refresh constantly. You absolutely, positively, without fail do NOT want to use active date/time formulas in a view selection or column formulas.

5

Subject: RE: yep, yep, yep

Fair call. The problem is though, all the repeat entries are stored in one single document, so even marking that document with an agent, won’t acutally fix the problem of showing all the recurring meetings every day. Would I be right in assuming that?

I will add an extra field for @today and see if that will fix the problem, but I am not sure if it will.

Thanks…

Steve