Filtering by collection with values of primitive types

[uxohotteixo]

Hi @alirezanet!
Thank you for your work in creating and maintaining Gridify!

Please give me some advice. I want to filter on collections of primitive types

Example:

{
    public string Name { get; set; }
    
    public int Age { get; set; }
    
    public IEnumerable<string> Emails { get; set; }
}

Here I want to filter users by email list. That is, I want to get users who have specific emails.

Using LINQ a query looks something like this:

var users = query.Where(u => u.Emails.Contains(firstEmail) && u.Emails.Contains(secondEmail));

How can I do this using Gridify?

[alirezanet]

Hi @uxohotteixo,

Maybe try something like this:

query = new QueryBuilder<User>()
	.AddMap("email", q => q.Emails.Select(q => q)) // you can also use GridifyMapper AddMap method
	.AddCondition("email =* [email protected], email =* secondEmail.test.com") // this is also same as AddFiltering extension
	.Build(query);

[uxohotteixo]

Works great thanks!