Alpha Video Training
Results 1 to 3 of 3

Thread: Filtering dropdown by session variable

  1. #1
    Member
    Real Name
    Roy Hofrichter
    Join Date
    Sep 2005
    Location
    Oak Hill, VA
    Posts
    12

    Default Filtering dropdown by session variable

    I'm trying to filter a grid drop-down by a session variable. Both V6 and V7 generate

    .DropDownBox.Filter = "Prop_Owner_Id=session.Unique_User"

    which seems to be completely ignored.

    There was another thread that talked about manually overriding this using either notepad (which seems to corrupt the file) or using a manual override feature in the October patch (which I am currently using). Suggestions are appreciated...

  2. #2
    Member David Brown's Avatar
    Real Name
    David Brown
    Join Date
    Sep 2003
    Location
    Miami, FL
    Posts
    133

    Default

    Inside of the component overide section of the page you need a filter like the one below.

    with tmpl.field_info[1] (The [1] should be changed to match the field # of the drop down. Look at the Xbasic for your component.)

    .DropDownBox.Filter = "Prop_Owner_Id="+session.Unique_User

    end with

    -David Brown

  3. #3
    Member
    Real Name
    Roy Hofrichter
    Join Date
    Sep 2005
    Location
    Oak Hill, VA
    Posts
    12

    Default

    David,

    Thanks for getting me pointed in the right direction. The code that worked in this case is:

    with tmpl_NewTask
    componentName = "NewTask"
    field_info[2].DropDownBox.Filter = "Prop_Owner_Id="+session.Unique_User
    end with

Similar Threads

  1. Dropdown box variable location for grids?
    By robert swanson in forum Web Application Server v6
    Replies: 2
    Last Post: 10-18-2005, 11:57 PM
  2. filtering on session variable
    By René Stout in forum Web Application Server v6
    Replies: 2
    Last Post: 09-04-2005, 01:30 AM
  3. Filtering a GridLinker using a Session Variable
    By Selwyn Rabins in forum Web Application Server v6
    Replies: 1
    Last Post: 06-23-2005, 04:17 PM
  4. lookup on a WAS session variable
    By John Haytko in forum Web Application Server v6
    Replies: 2
    Last Post: 09-13-2004, 05:48 PM
  5. Filtering a dropdown?
    By seidel1 in forum Web Application Server v6
    Replies: 3
    Last Post: 08-31-2004, 06:14 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
  •