GridView Filtering DomainDataSource

[Greek1]

I have a GridView bound to a DomainDataSource.   I want to filter the records based on who is logged in.... so I added the filter like so.

   ColumnFilterDescriptor recruiterColumnFilter = new ColumnFilterDescriptor((IDataFieldDescriptor)this.rgvCandidates.Columns["Recruiter"]);
            recruiterColumnFilter.FieldFilter.Filter1.Operator = Telerik.Windows.Data.FilterOperator.Contains;
            recruiterColumnFilter.FieldFilter.Filter1.Value = "Kev";
            this.rgvCandidates.FilterDescriptors.Add(recruiterColumnFilter);

When I ran SQL profiler I noticed that the query was returning everything and the filtering was happening all client-side.  I would like the grid to be filtered and have the filter symbol highlighted on the column....but I only want to retrieve the records needed.  If the filter is cleared on the gridView then go and retreive all the records.  I'm not sure this is possible but I thought I would ask.

Thanks

[Vlad]

Hi Greek1,

Can you post more info (XAML) how exactly the grid is bound to this DomainDataSource?

Regards,
Vlad
the Telerik team

[Greek1]

 <riaControls:DomainDataSource Name="CandidateDataSource"
                                      QueryName="GetCandidatesQuery"
                                      AutoLoad="True" FilterOperator="And">
                <riaControls:DomainDataSource.DomainContext>
                    <web:NeuHireContext/>
                </riaControls:DomainDataSource.DomainContext>
                <riaControls:DomainDataSource.FilterDescriptors>
                </riaControls:DomainDataSource.FilterDescriptors>
            </riaControls:DomainDataSource>

            <TGridView:RadGridView x:Name="rgvCandidates" telerik:StyleManager.Theme="Office_Blue"
                                   ItemsSource="{Binding ElementName=CandidateDataSource, Path=Data}"
                                   AutoGenerateColumns="False" Background="{x:Null}" Grid.Row="1" Margin="10" RowStyle="{StaticResource GridViewRowStyle1}"
                                   Foreground="{StaticResource DeepBlueTextBrush}" CanUserDeleteRows="False" CanUserInsertRows="False" EditTriggers="None"
                                   DataLoadMode="Asynchronous" RowIndicatorVisibility="Visible" >
                <TGridView:RadGridView.Columns>
                    <TGridView:GridViewDataColumn Header="First Name" DataMemberBinding="{Binding FirstName}" />
                    <TGridView:GridViewDataColumn Header="Last Name" DataMemberBinding="{Binding LastName}" />
                    <TGridView:GridViewDataColumn Header="Region" DataMemberBinding="{Binding Region.RegionName}" />
                    <TGridView:GridViewDataColumn Header="Practice" DataMemberBinding="{Binding Practice.PracticeName}" />
                    <TGridView:GridViewDataColumn Header="Stage" DataMemberBinding="{Binding RecruitmentStage.Display}" />
                    <TGridView:GridViewDataColumn Header="Status" DataMemberBinding="{Binding CandidateStatus.Display}" />
                    <TGridView:GridViewDataColumn Header="Recruiter"  DataMemberBinding="{Binding Recruiter.Login}" UniqueName="Recruiter"/>
                </TGridView:RadGridView.Columns>
            </TGridView:RadGridView>

Here you go

[Veselin Vasilev]

Hi,

One of the possible solutions is this:
Add the column filter descriptor in the LoadedData event of the domain datasource. This approach has the following pros and cons:
Pros: the filter funnel of the grid is updated accordingly. Clicking on the Clear filter will clear the filter and show all the data automatically.
Cons: initially all the data is loaded by the select query and then it is filtered. If you have a lot of data this would affect the initial loading of the page.

This was the easier option.


The other one is to work directly with the filter descriptors of the DomainDataSource.
Here is what you can do in this case:

1. Create filter descriptor of the DomainDataSource

System.Windows.Controls.FilterDescriptor filter = new System.Windows.Controls.FilterDescriptor()
{
    Operator = System.Windows.Controls.FilterOperator.Contains,
    PropertyPath = "Recruiter",
    Value = "Kev"
};

CandidateDataSource.FilterDescriptors.Add(filter);

This way only the filtered data will come to the client.

2. To update the filtering funnel of the gridview - you can add the custom filter descriptor to the gridview in the LoadedData event of the domain datasource (as in the first approach).

The problem with this approach is clearing the filter - it will clear the filter of the visible data (which is already filtered) because the domain datasource will still have its filter descriptor in place. You can subscribe to the Filtering event of the grid and manipulate the filter descriptors of the domain datasource as shown in our online demo.
Alternatively, you can have a separate Clear button on the page which will remove the filter descriptors of the domain datasource.

In addition, you can check this blog post:
Pure Server-Side Filtering with RadGridView and WCF RIA Services



Best wishes,
Veskoni
the Telerik team