Filter on one-to-many relationship

[flyspirit99]

I started to use Sieve a couple of days ago and love it. Now I encounter a situation and don't know how to do it by Sieve

I have a one to many relationship like below

public class Company
{
  public ICollection<Certificate> Certificates {get; set;}
}

public class Certificate
{
    public string Name {get; set;}
    public int CompanyId { get; set;}
    public Company Company {get; set;}
}

In CompanyApiController.GetCompanies() action, I need to filter company by its certificate name. Is this possible?

[elyasesna]

I am facing the same problem. if there is any way to filter on one-to-many relationship please let us know

[flyspirit99]

I resolved by using custom filter method

        public IQueryable<Company> CertName(IQueryable<Company> source, string op, string[] values) 
        {
            if (values == null)
                return source;

            var name = values.FirstOrDefault();
            if (string.IsNullOrWhiteSpace(name))
                return source;

            var result = source.Where(x => x.Certificates.Any(c => c.Name.Contains(name)));

            return result; // Must return modified IQueryable<TEntity>
        }