I have a large database with a categorized view by user name with a selection formula of CurrentUser != “”. To give each user their own tasks (that would be sortable) I have implemented a view that is public, private on first use that has a selection formula of CurrentUser = @Name([CN];@Username). This works the first time in but does not keep the view up to date. If I have the user delete the view and reopen it works properly.
Does anyone know why the view is not kept in sync and what I can do to keep it sync’ed? My users like the view since it allows them to sort on different columns (something that the categorized view embedded single category would not allow).
Would making the view store on the desktop be the answer to keeping it always up to date? If so, how do I delete it programatically when I need to?
Thanks,
LZ
Subject: Public Private On First View not correct
If by “up to date” you mean the Design of the view, there’s no way to do that short of deleting the existing private view and recreating it from the “pubic” copy. The “private” copy is a one-time operation - Notes does not try to sync them as changes are made to the pubic copy.
If the private views are stored in the database, then this could be done through Lotus Script. Search this forum, as I think the code’s been posted a couple of times.
Subject: RE: Public Private On First View not correct
Graham, thanks for your response. No, I have code that deletes the private view automatically when the public version changes. The problem is that only works when the private view is stored in the database. I was wondering if anyone has a solution when it is stored on the desktop.
Subject: RE: Public Private On First View not correct
Ah - I suspect that’s one of those things that’s Just Not Possible (and I’ve spent some hours tilting at that particular windmill).
If you ever find a way to do that, post it here, and you’ll be showered with accolades.