Grid filter records

Applications Grid / Reports
#1

Hello,

I have a Grid application and need only show only records that match a client.

Example … I have an application called “officials”, and I need to list only the fields corresponding Customer ID number 1.

In the database, I have a table called “officials”, there is a column called Customer ID in this column loads the customer ID.

As I can do to put the filter in the Grid? Grid only list that matches the customer ID to be assigned?

Best regards.

#2

in general:
change the sql statement so that it will have ‘where cusotmerid=1’. That will do it. When you want to make this dynamic you can use a where customerid=[glob_custid] and set the global variable somewhere in your application. Final option is to set a refined search.

#3

OK!.

Thank you for your assistance!