Analyze [login] to filter grid

Applications Grid / Reports
#1

I’d like to filter the output of a grid depending on the [login] global variable. How can I first check the login and then output the grid?

In concrete I have a users table with login field and a region_id field with a region a user belongs to.
When the user is logged in I only want to output data in the grid with the user’s region.

How can this be done?

#2

Solved it, thanks

#3

I’m trying to do this now. Do you have any pointers?

#4

adjust the grid’s SQL with a WHERE using a global variable with the login

eg …WHERE login = [glo_login]