I've used a couple of private on first use views for ages in one database I support. It seems like lately these have become flaky and are showing random docs. At first I thought this was related to Macs but it is happening on Windows clients as well.
Check out this scenario:
- POFU view is not showing the correct documents.
- Hit Create / View and Copy from the flaky view.
- Hit View / Go to and select the view I just created.
- It displays the correct list of documents.
This behavior seems so impossible it makes me think I'm missing something stupid/obvious. Any ideas?
Two other notes:
- In the last design replace I did a copy/paste of these views and then deleted the old ones in the design. I kept the same name but gave a different alias. I figured this couldn't hurt and might help since the design element would have a different ID under the covers.
- Maybe there is something on our production server or in that DB instance that's causing the problem. It works fine on out test server, and then in production it's messed up. If this might be the case, what should I ask fhe DBs admins to check or run? I don't see anything off in the DB properties.
Thanks!