Filter view of grid by user and value


Is it possible that based on the user that enters into the grid, the results of the grid get filtered? For example im my user 1 belongs to the City = “NYC” then he can only see the results in the grid of the records that have the City as NYC and so on

Yes it is possible.

  1. When the user logs in create a global variable depending on his City. eg: [user_city]
  2. In the grid SQL add the where city = [user_city]
1 Like