Complex EF ICollection

Question

Is this binding and filtering possible with Query Builder?

I have seen that there is filtering by nesting, could I use that with this object model?

(ICollection)

And I have another question:

-If I want to relate my parent class to another child class, it is enough for me to do this for bind or filter, right?:

QueryBuilderColumn Field="ClassParent.Child.Name"

In which cases is it recommended to replace this with nesting?

Keerthikaran Venkatachalam · Answer

Hi Sergio,We have checked the reported query and prepared a sample based on your requirements. Kindly refer to the below code snippet. @using Syncfusion.Blazor.QueryBuilder @code { SfQueryBuilder QueryBuilderObj; List Rules = new List() { new RuleModel { Field="Name", Label="Name", Type="String", Operator="equal", Value = "Mark" } }; public class ClassParent { public string Name { get; set; } public ClassChild Child { get; set; } } public class ClassChild { public string TypeID { get; set; } public string TypeName { get; set; } } } Get back to us if you need any further assistance on this.Regards,KeerthiKaran K V

Sergio Ayala · Answer

hi, you have not understood, the class child is an IEnumerable

YuvanShankar Arunagiri · Answer

Sorry for the inconvenience, Sergio. We don’t have support to load the IEnumerable model data source to the columns. The QueryBuilder component only supports the string, number, boolean, and object types of columns. And the object type is used for complex data-binding support, as we shared in our last update, which is similar to your requirement.For more details about complex data binding in the query builder, kindly refer to the below links.Demo link: https://blazor.syncfusion.com/demos/query-builder/complex-databinding?theme=fluentUG link: https://blazor.syncfusion.com/documentation/query-builder/data-binding#complex-data-bindingThe class definition should be like this. public class ClassParent { public string? Name { get; set; } public virtual ICollection Childs { get; set; } = new List(); } public class ClassChild { public AnotherClass? MyType { get; set; } } public class AnotherClass { public int TypeId { get; set; } public string? TypeName { get; set; } } Using the complex data binding support of query builder, we can set the parent column's object type and child columns within the parent. Check with attached sample code file and get back to us, if you need any further assistance on this. Regards,YuvanShankar Attachment: Index_3cdc1a67.zip