When upgrading the Rooms and Resources database from r4.6 to R6.01, it appears that there is a field missing in existing documents that prevent them from being selected in the views.
For example, the view Reservations by Date… the old view selection formula was
SELECT Form = “Reservation”
now the selection formula is:
SELECT (@Contains(Form; “Reservation”)) & (@IsAvailable($BusyName) & $BusyPriority = “1”)
but there is no field in pre-existing documents called “$BusyPriority”… therefore, no documents are showing up in the view!
I don’t see anything about running an agent to update existing documents. Do I have to write one myself? Any other implications to doing this? Did anyone else have to do this??
Thanks!
Anastasia