Filter one-to-many relationship

[flyspirit99]

Discussed in #153

^{Originally posted by flyspirit99 August 4, 2021}
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?

[ameckl]

I'm don't know if that is possible using SievePropertyMapper, but you can implement the ISieveCustomFilterMethods interface.

public IQueryable<Company> CertificateName(IQueryable<Company> source, string op, string[] values)
{
    return source.Where(company => company.Certificates.Any(certificate => values.Contains(certificate.Name)));
}

Take at look at: https://github.com/Biarity/Sieve#add-custom-sortfilter-methods

[bauermalzwei]

I can confirm what @ameckl suggested. I had the same challange and it works fine with ISieveCustomFilterMethods
You just have to use the method name in the URL e.g.: /api/companies?page=1&pagesize=10&filters=CertificateName==MyFancyCertificate