[Solved] How to filter related child objects ?

[Stef Heyenrath]

I've this Entity :

public class MyEntity
{
    public string Name {get;set;}
}

A simple filter on a Property is defined as follows:
FilterDescriptor filter = new FilterDescriptor();
filter.PropertyName = "Name";
filter.Operator = FilterOperator.Contains;
filter.Value = "abc";

and can be accessed using :
query = query.Where(ExpressionBuilder.Expression<MyEntity>(command.FilterDescriptors));


But to define a filter to that I can filter on Child Objects ?
public class MyComplexEntity
{
    public string Name {get;set;}
    public IList<OtherEntity> List {get;set;}
}

public class OtherEntity
{
    public string Title {get;set;}
}

FilterDescriptor filter = new FilterDescriptor();
filter.PropertyName = "List.Title"; //   ???
filter.Operator = FilterOperator.Contains;
filter.Value = "xyz";

[Rosen]

Hello Stef Heyenrath,

I'm afraid that this is not currently supported. 

Regards,
Rosen
the Telerik team

[dwhite]

Has this changed? I have a list of strings. which the grid displays fine (comma-delimited), but I would like the users to be able to filter based on one of the words in the list.

My object is like:

public class Company {
  public string Name { get; set;}
  public List<string> Categories { get; set; }
}

If I enable sorting (e.g. just sort by the comma-delimited string that is displayed) it fails and filtering does as well.

I've tried other strategies like joining a string in the object (read-only property with a string.Join), but that fails because LINQ doesn't know how to use those in a query. I've also tried a string.Join in my LINQ query itself, which fails because string.Join can't be converted to a store function.

Thanks,
-Damien

[Rosen]

Hi,

Unfortunately, this is still not supported. You may consider using custom binding and handle the binding through your own custom routine.

Regards,
Rosen
the Telerik team

[Stef Heyenrath]

Some things you can do:
1) Use custom binding as described by Rosen.

2) If a company does not have that many categories, you can add this a column to the Company table, like "CompaniesAsCSV".

3) You can build a VIEW which does all the joins and creates a CSV list. (See this)


If you did not need a filter and sort on a CSV list, but just on a string like "Fullname" (which is Firstname + Lastname) you could use Linq.Translations.