I want to have view criteria that will only return db rows when the current loginuser matches the added_user on rows on the db OR if a given loginuser other than the current loginuser is using the view.
I am able to accomplish the first part using the following criteria without an issue:
added_user == zoho.loginuser
But when I try to include an 'or' condition that would allow a manager to view all of the db rows regardless if their loginuser matches rows on the db or not I get an error message 'adding criteria failed'. zoho.loginuser 'smith' is the manager in my example below.
added_user == zoho.loginuser || zoho.loginuser == "smith"
Any ideas on what I may be doing wrong? Thanks for your help.