view selection formula problem
Posted on 2003-03-24
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..