Alpha Video Training
Results 1 to 2 of 2

Thread: Filter Grid Based on Page computed where clause

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

    Default Filter Grid Based on Page computed where clause

    <%a5
    'compute the where string for this grid (heavily dynamic where clause with dynamic # of conditions)
    dim wherestring as C=""
    if condition1==true then
    wherestring=wherestring+"omit_list_online=0"
    end if

    dim componentAlias as c
    componentAlias = "mygrid"
    Delete tmpl_mygrid
    DIM tmpl_mygridas P
    tmpl_mygrid = a5w_load_component("grid102931023")
    tmpl_mygrid.base_filter=wherestring
    %>

    This will save somebody HOURS of work.
    I have done this b efore - but the documentation for this is deeply hidden (I couldnt even find it again).

    GOodluck :/
    Scott Moniz - Computer Programmer/Analyst
    REA Inc.
    http://reainc.net
    (416)-533-3777
    scott@reainc.net

    REA INC offers consulting services, programming services, systems design, database design, third party payment gateway integration (CHASE, PAYPAL, AUTHORIZE.NET) and developer support.
    If you need custom code, or 1-to-1 mentoring in any facet of your database/web application design,
    contact us to discuss options.

  2. #2
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,310

    Default Re: Filter Grid Based on Page computed where clause

    Scott, is this for a desktop app?

Similar Threads

  1. Filter Dropdown list in SEARCH part, based on grid filter
    By lgrupido in forum Application Server Version 10 - Web/Browser Applications
    Replies: 1
    Last Post: 03-28-2011, 06:05 PM
  2. Grid>Query>Filter based ONLY on an argument
    By rnoguera in forum Application Server Version 10 - Web/Browser Applications
    Replies: 0
    Last Post: 07-14-2010, 08:43 AM
  3. LIMIT clause in grid
    By Peter.Wayne in forum Application Server Version 10 - Web/Browser Applications
    Replies: 3
    Last Post: 02-21-2010, 11:38 PM
  4. Need to filter grid based on dialog
    By crimmelcp in forum Application Server Version 9 - Web/Browser Applications
    Replies: 4
    Last Post: 10-29-2008, 02:49 PM
  5. computed column in grid
    By ravish in forum Application Server Version 8
    Replies: 0
    Last Post: 02-01-2008, 01:01 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
  •