Complex filtering with dynamic datasource

Question

Hello,The project type is: Blazor ServerThere is a combobox with manually populated datasource as ObservableCollection.There is only the top 10 items are retrieved and shown.I added filtering via the fitering event, it works well for the datasource, but the collected items are not shown in the combobox.It's because I need to set the FilterType, which only accepts: Contains / StartsWith / EndsWith, meanwhile my manual filtering is something like: ContainsAnyWordI suspect that the built in Filtering is applied over the manually filtered datasource, which gives 0 result. But without setting the FilterType there is no result at all.The control is briefly:                                                 AllowFiltering="true" FilterType="SfDDFilterType.Contains" >                                                Created="CB_Created"                                Filtering="CB_Filtering"                                ValueChange="CB_ValueChanged"/>                                                                                       My question is how to use the custom datasource with manual filtering, ignoring the built in filter logic?

Ponmani Murugaiyan · Accepted Answer

Hi Istvan,  

Greetings from Syncfusion support. 

Query: How to use the custom datasource with manual filtering, ignoring the built in filter logic? 

As per your requirement “to filter the dynamically added items in the datasource(ObservableCollection) using filtering event”, we have prepared sample. Please find the code snippet for custom filter using filtering event below for reference. 





public void onFiltering(Syncfusion.Blazor.DropDowns.FilteringEventArgs args) 
    { 
        args.PreventDefaultAction = true; 
        var query = new Query(); 
        if (args.Text != "") 
        { 
            query = new Query().Where(new WhereFilter() 
            { 
                Field = "Name", 
                value = args.Text, 
                Operator = "Contains", 
                IgnoreCase = true 
            }); 
        } 
        this.CBFilter.Filter(VendorProductSelection, query); 
    } 

Sample: https://www.syncfusion.com/downloads/support/directtrac/general/ze/Combobox_Custom_filtering1595842147  
 
Kindly check with the above sample. If issue still exists in your end or if we misunderstood the query, please provide the below details. 


Whether used complex data in your datasource.
If possible replicate the issue in the provided sample.

The above requested details will helps us to provide you the solution at earliest. 
 
Regards, Ponmani M

Istvan Piroska · Answer

The code is:

Istvan Piroska · Answer

Perfect, thank you!Applying the following filtering code after the manually populated datasource is does the job.                e.PreventDefaultAction = true;                var filter = "";                if (!string.IsNullOrWhiteSpace(e.text))                    filter = e.text;                var fs = filter.Split(" ");                var query = new Query();                foreach (var s in fs)                     query = query.Where(new WhereFilter                    {                        Field = nameof(VendorProduct.SkuName),                         value = s,                         Operator = "Contains",                         IgnoreCase = true                    });                CBFilter.Filter(VendorProductSelection, query);

Ponmani Murugaiyan · Answer

Hi Istvan, 

Thanks for the update.  

We are glad to hear that the provided suggestion helped you in achieving your requirement.  

Please get back to us if you need further assistance. 

Regards, 
Ponmani M