I have searched about my problem but can not find anything that can be used for my purpose so any help is appreciated.
Basically I have a postgresql DB connected as data source and it contains a very large table that stores logs of different projects. The projects are separated with project_id’ and I have placed a dropdown list in my query to get the results that belong to specific projects.
Now what I would like to do is to limit the parameters a different user can see because the dashboard will be shared with different project managers and they have to be restricted to see only the logs that belong to their project_id’s.
I thought I can do this if I get the parameters with a query based dropdown list which can return project_id’s that belong only to the active user but in order to do that I need to have a parameter that belongs to the current user or group. Is this possible? Is there another way to achieve the same result?
Thanks for the help!