Single view multiple users

HCL Domino Domino Forum
1

Scenario: User enters database to find a frameset and a embedded view. I would like for the user to see only documents relating to them.

Selection formula-

WkUserList :=@Unique(@Name([CN];@Trim(Supervisor :EmployeeName :Readers)));

SELECT (Form = “Employee Data”) | (form = “Employee Form”) | (Form = “Managers Form”) & @Contains(WkUserlist; @Name([CN]; @UserName))

Any idea of how to accomplish this? Does it come down to a cache issue? Would this be better accomplished through Author and Reader fields? And if so I would not want the user to see a list of categories that they can not view.

Thank you

Steve

2

Subject: Single view multiple users

This (the use of @UserName in view selection formulas) may be the most frequently asked question in this or any other Notes/Domino discussion forum. The short answer is that it doesn’t work. The documentation on @UserName gets into details, and a search of this forum will turn up several discussions of the alternatives. Briefly put, they are:

Private views

Embedded views

Readers fields

I tend to go with the second, but the specific circumstances of what you’re after may cause you to go another way.

3

Subject: RE: Single view multiple users

M,

Thank you for your response. I am familar with the fact that they say @username does not work in a view.

We currently have a third party software package that has a view set up to show only individual users documents. It works great. They utilize a external db as a cache clearinghouse. So when two users enter the same view it shows only their data. For the most part the code I posted is what is in the selection formula for that view.

I was just posting to keep the current application as simple as possible.

Again thank you for the response. This is a learning tool

Steve

4

Subject: Sounds like a private-on-first-use view

5

Subject: RE: Sounds like a private-on-first-use view

Bruce

I tried to embed the private-on-first-use view and it is not showing up in the list is this possible?

Thank you,

Steve

6

Subject: RE: Sounds like a private-on-first-use view

I tried to embed the private-on-first-use view and it is not showing up in the list is this possible?

Yes. Private-on-first-use views do not show up in the Insert Embedded View dialog. If the UI design dictates that the view needs to be embedded in a page or form, then use one of the other approaches M Riggsby cited originally.

7

Subject: RE: Single view multiple users

To clarify, in this case you’d create your view with a categorized, hidden column of names. Then in the form that the view is embedded in, set the view to be Single Category. Set the single category formula to evaluate to the name of the user.

8

Subject: RE: Single view multiple users

Esther,

Thank you for the posting. I think this may lead to a solution.

Thanks again,

Steve