[Solved] Multiple filters on grid - syntax?

[Raymond]

Hi,
I can add an initial filter like this:

.Filterable(filtering => filtering.Filters(filters =>

{

filters.Add(obj => obj.OwnerFirstNameLastName).StartsWith((

 

string)this.ViewData["OwnerName"]);

 

}))

However, for the life of me, I can't figure out how to add multiple filters. Can someone show me the proper syntax?

Thank you.
Ray

[Jake]

Took me a while to find it to, but here you go...

.Filterable(filtering => 
        {
            filtering.Filters(f => f.Add(o => o.CUSIP).StartsWith(Model.CUSIP));
            filtering.Filters(f => f.Add(o => o.Quantity).IsGreaterThanOrEqualTo(Model.QuantityLow));
            filtering.Filters(f => f.Add(o => o.Quantity).IsLessThanOrEqualTo(Model.QuantityHigh));
......and so on......          
        }                
    )

If you have nullable data types or provide empty values you may receive "null is null or not an object" JS errors. You'll need to adjust the values accordingly or change the type of comparison you are using.  For example, if you attempt to provide an empty string value when using Contains() you will receive the JS error. In this particular case you will need to change your comparison to StartsWith() or change your value.