Hi Team,
I have a requirement where I have a dashboard to display list of Projects created by a User under My Projects
I have another dashboard where users can see all the Projects created by all the users including themselves -- Under All Projects
I have a field ID on All Projects Dashboard -- > which is a link and when on click on takes you inside of the project to see the details.(This is the only link which takes you inside the project on click)
But, under All Projects I need to have a condition that if the particular Project is Restricted(this is a Database column) then the ID field should not be clickable(not able to go inside the project) by the unauthorized user except the one who created it.
My question is I am trying to do this using Authorization Scheme, which is a custom made by me and the query is working fine and I applied the Scheme on ID field of my query(used in the Interactive Grid).
The Problem with the query is I am checking with the :app_user if the user is authorized or not, if the query is false and the complete ID column is not displayed for the user logged in even his own Projects he cannot click(as the complete column is missing because of the scheme).
Any help would be appreciated.
Regards,
Saikumar Katepalli