Alpha Video Training
Results 1 to 2 of 2

Thread: Filter Dropdown list in SEARCH part, based on grid filter

  1. #1
    "Certified" Alphaholic
    Real Name
    Larry Grupido
    Join Date
    May 2010
    Posts
    1,718

    Default Filter Dropdown list in SEARCH part, based on grid filter

    In a linked GRID search, I want to created a drop down list that has values dependent upon the linked grid filter.

    So, my main grid is "trips" which has a primary key of trip id. I have a linked grid "participants" which is linked by the trip ID. In those participants, I have different participant types.

    For purposes of this discussion, let's say (Quad, Double, Triple, Single).

    I want to be able to search by participant type, but I only want to show values in the drop down that apply for that trip.

    So, if the trip only has Quad and double participants, I do not want to have a triple value in my search options.

    To do this, I have to create an Xbasic funtion to build a variable to assign to my dropdown. I get that part.

    I don't know how to use the current grid filter in my xbasic function though. Alternatively, if I could simply get the ID from the main grid, that would work too.

    Larry

  2. #2
    "Certified" Alphaholic
    Real Name
    Scott
    Join Date
    Mar 2010
    Location
    Toronto,ON
    Posts
    1,030

    Default Re: Filter Dropdown list in SEARCH part, based on grid filter

    Take a look at the OnGridSearchFilterCompute.

    Put a debug(1) in that event and launch the grid in working preview. You should be able to see how it computes filters and manually override the code

Similar Threads

  1. Filter Grid Search Dropdown
    By steinmanal in forum Application Server Version 10 - Web/Browser Applications
    Replies: 5
    Last Post: 09-08-2009, 10:27 PM
  2. Use existing Grid Search Part filter to print report
    By den1s in forum Application Server Version 8
    Replies: 0
    Last Post: 09-21-2007, 10:22 AM
  3. quick search dropdown filter in grid based on view.
    By Pat Bremkamp in forum Web Application Server v7
    Replies: 2
    Last Post: 07-30-2007, 08:30 AM
  4. Filter search part of grid with variable
    By Walter in forum Application Server Version 8
    Replies: 2
    Last Post: 05-18-2007, 09:23 AM
  5. Date Based dropdown list filter does not filter
    By Steve Bovino in forum Web Application Server v6
    Replies: 17
    Last Post: 10-15-2005, 08:36 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •