Announcement

Collapse
No announcement yet.

Grid filter records

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Grid filter records

    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.
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment


    • #3
      OK!.

      Thank you for your assistance!

      Comment

      Working...
      X