filtering a radgrid with multiple queries

3 posts, 0 answers
  1. Prateek Bahl
    Prateek Bahl avatar
    8 posts
    Member since:
    Dec 2009

    Posted 18 Mar 2010 Link to this post

    Hi, I have a gridview that needs to be bound to 1 main query and 2 other queries to fill in the rest of the columns.  Here are the problems I am having: (note: the queries are binded to the grid prgrammatically using datasets and the language I am using is C#).
    1. when I pass the FilterContainerID,
      • When I click on Apply button, i am able to generate the right query but the gridview doesn't get affected.
        • When I use the Apply filter button on the gridview, it works.  This is the closest I got to getting the filters to work.
      • Only the columns from the main query are shown in the filter and the columns data type are incorrect.
    2. when I manually add the filter columns,
      • Even though it generates the right query, not only does the radgrid not get affected, i get different errors.
        • for both the Apply Button and the Apply filter button on the gridview.

    I tried looking for some examples or explanations, but was unsuccessful.  Can you please post an example or links to help me out with the following scenario.

    Thank you for your help,

  2. Nikolay Rusev
    Nikolay Rusev avatar
    2287 posts

    Posted 19 Mar 2010 Link to this post

    Hello Prateek,

    Currently RadGrid will supply information only for the columns in RenderColumns collection to RadFilter.
    Then RadFilter will be able to build the expressions only for this columns and apply the expressions on RadGrid.

    If you need to filter on more columns you should have them in Columns collection in RadGrid.
    I hope this helps.

    All the best,
    the Telerik team

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
  3. adam
    adam avatar
    15 posts
    Member since:
    Sep 2010

    Posted 21 Oct 2010 Link to this post

    you can generate the column data and then just not show it

    <telerik:GridTemplateColumn Visible="false" 
Back to Top