<div>
<div class="content wysiwyg-content">
Ok, I think I am going mad over this one. I am trying to create a view where the current DB user sees all the documents where their username is listed in a specified field within those documents. This is my view selection:<br />
<br />
<br />
SELECT (@name([CN];@username))=(@<wbr />name([CN];<wbr />selecttitl<wbr />e_10))<br />
<br />
Selecttitle_10 is a name field.<br />
<br />
Now, it seems to work, but, when I switch user IDs and select that view again, it displays the previous user IDs documents ather than the current user ID's documents. I have to go into design, refresh the view using the curly thing at the top left, close and save it and then the view is updated with the new user IDs documents. This is a bit frustrating, it's as if the view is not refreshing when the DB is accessed by a new user.<br />
<br />
Anyone got any idea's of what I am doing wrong or am I just expecting too much?<br />
<br />
Paul<br />
Sydney
</div>
</div>


Ok, I think I am going mad over this one. I am trying to create a view where the current DB user sees all the documents where their username is listed in a specified field within those documents. This is my view selection:


SELECT (@name([CN];@username))=(@name([CN];selecttitle_10))

Selecttitle_10 is a name field.

Now, it seems to work, but, when I switch user IDs and select that view again, it displays the previous user IDs documents ather than the current user ID's documents. I have to go into design, refresh the view using the curly thing at the top left, close and save it and then the view is updated with the new user IDs documents. This is a bit frustrating, it's as if the view is not refreshing when the DB is accessed by a new user.

Anyone got any idea's of what I am doing wrong or am I just expecting too much?

Paul
Sydney

Viewing documents where the current user equals the user name in a specified field

Lotus Software produced the Lotus 1-2-3 spreadsheet program, and later developed Lotus Notes, a groupware and email system. Following its acquisition by IBM, the Notes and Domino client/server collaborative platform were expanded to include functions such as email, calendars, to-do lists, contacts management, teamrooms, discussion forums, file sharing, microblogging, instant messaging, blogs, and user directories. IBM also release SmartSuite, a comprehensive office suite, and followed that with Symphony, unrelated to the Lotus suite of the same name.