Hi all - I hope you're all keeping well!
Due to a view taking too long to load on the web (possibly due to SELECTION formula which is not exactly all that heavy) I've decided to add a Readers-type field to my main document. That readers field returns a name or list of names in Canonicalized format. It also returns 1 role as an element of the list of readers.
Now, when I force values into the readers-type field while working in the Notes database, the view acts as I expect. However this activity is not reflected on the Web.
Obviously if I create a document on the web the readers-type field automatically generates the list of names who can read it. However I noticed that by changing the readers field values via a simple agent in Notes that the only common factor that maintains a records visibility on the web is the ROLE that is in the list. Worse again, the user logged into the web does not have that role as either a single person or Group Member on the ACL.
I'm very confused now. The Group to which the logged-in user belongs has Manager access in the ACL so should be able at the very least see their records in the view as their name is included in the Readers field. The view has a very simple selection formula so that can't be the issue.
Can the Web identify the logged-in user against the readers fields? I don't see anything in Domino help to suggest not.
I'm sure it must also be ok to call the Readers-type field anything I want or must I call it "Readers"?
I'm grasping at straws again as the obvious isn't working for me. You're help would be greatly appreciated people!! Thanks in advance, noloco.