Domino/Notes Version: 12 FP5
Add-on Product (if appropriate, e.g. Verse / Traveler / Nomad / Domino REST API):
Its Version:
Operating System:
Client (Notes, Nomad Web, Nomad Mobile, Android/iOS, browser version):
Problem/Query:
From my calendar I have the possibilty of booking a room in our room and resources database. The calendar “meeting” form contains a button which uses forumula language to perform a lookup. All available rooms are then displayed using a subform and I can choose which room I wish to book.
The problem I have is that one room contains several readers fields. However it is possible for people not listed in any of the readers fields to view and book the room from the subform.
Should not being included in the readers field prevent a user from even seeing this room?
The only possible reason for this that I can think of is that the lookup is being performed using a server id rather than the id of the current user - is this possible?
Hi Andrew
Yes. If the lookup is being performed using server id, it is showing all the documents. You can cross
check by writing a standalone simple code and see whether rooms are showing when lookup done with the userid.
Thanks for your reply. Is there a way to check which ID (Server or User) is being used when performing a formula language lookup?
Hi Andrew
Can you explain how the lookpup is performed? Complete logic would help here to identify.
@FindFreeResource(Keyarg;tmpResourceType;tmpStartDateTime;tmpEndDateTime;tmpCapacity;9999;[WITHCAPACITY]))
This forumula returns a list of rooms which are available to be booked. Unfortunately it returns ALL available rooms including ones which contain a readers field which excludes the current user.
The formula is executed from the users mail file. The rooms are defined (one document per room) in a separate database. When users open the database containing the rooms, they only see the rooms whose reader field allows them visibility of that room. On the contrary, when performing the Lookup from their mail file, users see ALL rooms, regardless of the contents of the readers field.
Hi Andrew
You mentioned “The formula is executed from the users mail file.”. How this is being executed? Is it through any agent, button on any Form, etc?
1 Like
It is executed by clicking on a button. Actually the problem is now solved. I just edited and saved the room document without making any change. Now the lookup only shows rooms which users are entitled to see - the readers field now performs as expected. I am not sure what could have caused the problem but am happy that it is now resolved. Thanks very much for your help.