SPR

Technote

Problem:
This issue is tied to the Selection formulas used for the views. This issue
was reported to Quality Engineering and was fixed in the Resource Reservation
template which ships with Notes 6.0.4 and 6.5.2.

Excerpt from the Lotus Notes and Domino Release 6.0.4 and 6.5.2 MR fix lists
(available at http://www.ibm.com/developerworks/lotus/):

Template
SPR# OBEN5PPMCL - Reservations created in Resource Reservation database in R4
do not show in 'By Date' view after migration to R6. This problem has been
fixed in 6.0.4 and 6.5.2.

The revised 6.0.4/6.5.2 selection formula for the views 'Reservations By Date'
and 'Reservations By Resource' are as follows:

SELECT (@Contains(Form; "Reservation") & @IsAvailable($BusyName) & (
!@IsAvailable($BusyPriority) | ($BusyPriority = "1" &
@IsAvailable($CSVersion) ) ) )

The revised 6.0.4/6.5.2 selection formula for the 'My Reservation' formula is
as follows:

SELECT (@Contains(Form; "Reservation") &
(@IsMember(@UserName; Author) | @UserName = Chair)
&@IsAvailable($BusyName)
& ( !@IsAvailable($BusyPriority) | ($BusyPriority = "1" &
@IsAvailable($CSVersion) ) ) )


Note: Several customers have noted that the above formulas still do not
display all of the expected documents. A request to have the Software Problem
Report re-opened for examination has been made.

Workarounds:
The following workaround has not been reviewed by Quality Engineering at this
point in time. It is suggested as a temporary workaround to allow the viewing
of the expected reservations.

A revision to the selection formulas can be made which will force all of the
expected documents to display. Note: Because Notes 4.x used different logic in
its design of these features it is possible that attempting to perform some
operations on these legacy documents may return an error.

The following formula can be used for the 'Reservations By Date' and
'Reservations By Resource' views:

SELECT @Contains(Form; "Reservation") & @IsAvailable($BusyName) &
($BusyPriority = "1" | (!@IsAvailable($BusyPriority) &
!@IsAvailable($CSVersion)))

The following formula can be used for the 'My Reservations' view:

SELECT (@Contains(Form; "Reservation") &
(@IsMember(@UserName; Author) | @UserName = Chair)
&@IsAvailable($BusyName)
& ($BusyPriority = "1" | (!@IsAvailable($BusyPriority) &
!@IsAvailable($CSVersion))))

This view is a "Shared, Private of 1st use" view, and so the new View Selection
formula must either be edited in both versions (shared and private) or the
shared (master) must be edited and the private version deleted and re-created.
If making this modification in a template it will be easier to have users
delete the private version and then re-create the view which will then be based
on the revised shared version. In the Domino Designer the Shared version of
the view has a key with a number 1 on top of it that appears like this: . In
the Designer client the Private version has only a key next to it that looks
like this:. In the Notes Client the Private version of the view exists when
then name has a yellow view icon with a smaller overlapping rectangle in the
lower right corner (like this: ).

Delete Private View and Update Shared View
1. Delete the private version of the view by either of the below:
i. From the Notes Client select the private version of the view in the left
pane. Look for an icon like this: . Press the F6 key to give it focus, and then
press the DELETE key.
- or -
ii. From the Designer client locate the "My Reservations" view which has a key
(with no number 1) and delete it.

2. Replace the View Selection formula for shared version (with the key and the
number 1) with the formula noted above.

3. From the Notes Client select the view in the left pane to re-create the
private version.

- or -

Update both Private and Shared Views
1. Replace the View Selection formula of the private version (with the key) of
the view with the formula below.
2. Replace the View Selection formula of the shared version (with the key and
the number 1) with the formula noted above. More >