I have a mailing list database that was written in Designer 5.0.12 and a new copy created on a 6.01 server. The design has be edited with 6.01 Designer.
-
has two simple forms “List” and “RSVP” filled in from web by “anonymous” users. Form is also available from Notes Client for editing.
-
Each form has 3 shared views. The views have only one computed field - LastName + ", " + FirstName and the rest of the fields are just
database fields or system fields.
- When creating the views neither form shows up in Designer as being available for a view selection, but does work when used by formula.
A third form does show up, but it is not used in any of the problematic views. When I try to use the form as a Condition I get error “Invalid or non-existent document”. When I use it in formula it does use the correct form in the view.
- All users are currently set as Manager, except Anonymous which is set as Author.
Problem: The data doesn’t show up in the view based on “List” for any user other than me. The other 3 views show all of the data. I have tried different selection formulas and the result is the same.
What I’ve tried: Recreating the views from scratch. Creating a new “List” form. All no avail.
Only when the “Enforce consistent Access Control List across all replicas is unchecked” can any other user but me see the data - and then only in the Replica not in the server copy.
Subject: Views not showing documents for some users.
That your forms don’t show up in the selection, is normal - the form property ‘Include in Search builder’ is deselected.If all users are manager (which is a bad thing in general by the way), and you have the same rights as them and the documents do show up in replica’s and other views, your view selection must be wrong. Can you post it ? I sense an @username in there …
cheers,
Tom
Subject: RE: Views not showing documents for some users.
Tom - the view selection is:
SELECT FORM = “List” for the first view
SELECT FORM = “RSVP” for the second view
The first view shows the 1000 or so records and their field data.
The second view does not.
The other two views for each forms are just categorized views of same info with same selection formula.
I can log in and see all of the data in all six views. My other users can only see data in the RSVP view. The database acts like the data is their (example: rebuild the index takes some time), but the data for the views columns just don’t display.
Any more info I can provide … I will.
Subject: RE: Views not showing documents for some users.
It’s not a private view by any chance ? Are there access restrictions on the view (read rights) ?
cheers,
Tom
Subject: RE: Views not showing documents for some users.
No restrictions on views. Views are shared. When I create new views using the List form they behave the same as the other ‘errant’ forms.
Can send you the db if you like. If you enjoy a mystery.
Subject: RE: Views not showing documents for some users.
If you can make the db smaller than about 2 mb, you can mail it to me. (please remember to set the default entry in ACL to manager)If not, let me know, I’ll provide a url to upload.
cheers,
Tom
Subject: RE: Views not showing documents for some users.
Hi, I’m not very experienced in Notes developing, but maybe this will help.
I have also had problems getting SELECT statements to display the documents for users other than myself.
I don’t know if this will apply to your situation, but to make it work for me, I had to modify my select statement to the following:
SELECT (Form = “Service” | $Title = “Service”)
Before I added the $Title part, it would only display documents that were submitted from a web browser. Have you tried submitting from a web browser & Notes?
Subject: RE: Views not showing documents for some users.
Tim - thanks, tried this with no effect.
Subject: RE: Views not showing documents for some users.
It works fine from a web browser. Just not in Notes client.