view selection formula problem

Posted on 2003-03-24
Medium Priority
Last Modified: 2013-12-18
 The application I am building has two views..
  a, feedback received.. list of all the docs the user has received from others
  b, feedback givne.. list of all docs the user has given to others..

  In order to maintain privacy.. i have author and reader fields.. in the doc.. with readers rights given only to the author and the recipient of the doc.

  The view selection formula for the feedback received view is
  SELECT (( Form = "Feedback")  &(Published = "Yes"))  & (Deleted != "Yes") & (Ratees = @Right(@Left(@UserName;"/"); "="))

  The view selection formula for the feedback given view is
  SELECT (( Form = "Feedback")  &(Published = "Yes"))  & (Deleted != "Yes")

  However, the feedback given view shows the docs the user has given as well as received. And the feedback received view shows the same..  and i dont know how to fix this.

  Since both the author and the reader can see the document.. they end up being seeing in both the views. But I wanted the author to see the doc in the feedback given view only.. where as the recipient should see it in the feedback received view only...

How should I fix this?

Any help in this regard would be greatly appreciated..


Question by:arask2
  • 2
LVL 24

Expert Comment

ID: 8197549
Change this

(Ratees = @Right(@Left(@UserName;"/"); "="))


@Contains( @UserName; Ratees)

in your formula


Author Comment

ID: 8197983
Tried @contains(@userName;Ratees).. but the problem still persists...

both the author and the receiver see the document in the view.. feedback received.. its as if the @contains does not even take effect.

The view selection formula that was used to test it is given

SELECT (( Form = "Feedback")  &(Published = "Yes"))  & (Deleted != "Yes") & @Contains( @UserName; Ratees)


Accepted Solution

krisjaniz earned 400 total points
ID: 8202707
I hope these views you create are private, because you cannot use @UserName in a public view.

From Designer help:

"...You should not use @UserName in a public view, doing so will produce unpredictable results. Also, if the field that you are referencing changes, you will get unpredictable results because the index has to be rebuilt to accommodate the new information."

"...However, the user can still design a different private view that retrieves all documents, so don't depend on @UserName as a security mechanism."
LVL 24

Expert Comment

ID: 8203289
Yes the view should be private on first use if you are using @username in a view selection ( I assumed it that you already setup that way), Anyway Krijaniz got the point.


Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Suggested Courses

592 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question