This is a migrated thread and some comments may be shown as answers.

filtering a radgrid with multiple queries

2 Answers 83 Views
Filter
This is a migrated thread and some comments may be shown as answers.
Prateek Bahl
Top achievements
Rank 1
Prateek Bahl asked on 18 Mar 2010, 07:19 PM
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,

Pat

2 Answers, 1 is accepted

Sort by
0
Nikolay Rusev
Telerik team
answered on 19 Mar 2010, 12:58 PM
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,
Nikolay
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.
0
adam
Top achievements
Rank 1
answered on 21 Oct 2010, 01:27 PM
you can generate the column data and then just not show it

<telerik:GridTemplateColumn Visible="false" 
Tags
Filter
Asked by
Prateek Bahl
Top achievements
Rank 1
Answers by
Nikolay Rusev
Telerik team
adam
Top achievements
Rank 1
Share this question
or