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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

718 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