Results 1 to 2 of 2

Thread: Set Filter from picklist using rsp file

  1. #1
    Junior Member
    Join Date
    Feb 2012
    Posts
    21

    Set Filter from picklist using rsp file

    Hi
    I am trying to set a filter to Vendor on a product file using an rsp file to list the available vendors.

    I have created an rsp file and I am able to generate a Dialogpanel with a list of vendors , using
    open database essdata
    Select vendor from webprod_add order by 1 group by 1 into cursor cVendor
    select cVendor
    list html off fields vendor;
    onclick "vendor","filtervendor('{}')"

    However I am unable to apply the filter to the section. I tried using both the field name and a vendor name, with no luck.

    Javascript code in the rsp file.
    function filtervendor(vendor)
    {
    Lianja.showDocument("pageage1");
    //Lianja.showDocument("section:webprod?action=filter &text = startswith(vendor,'LILLY')");
    Lianja.showDocument("section:webprod?action=filter &text = startswith(vendor,'{vendor}')");
    Lianja.hideDialogPanel();
    };
    }

    Any help will be appreciated
    Paudie

  2. #2
    Lianja Team yvonne.milne's Avatar
    Join Date
    Feb 2012
    Location
    Berkshire, UK
    Posts
    1,460
    Hi Paudie,

    Try this:

    Code:
    Lianja.showDocument("section:webprod?action=filter&text=startswith(vendor,'"+vendor+"')");
    Regards,

    Yvonne

Bookmarks

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
  •  
Journey into the Cloud
Join us