asked on

view selection formula problem

Gurus,

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..

thanks

HemanthaKumar

Change this

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

to

@Contains( @UserName; Ratees)

in your formula

~Hemanth

arask2

ASKER

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)

ASKER CERTIFIED SOLUTION

krisjaniz

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

HemanthaKumar

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.