QueryDesigner
QueryDesigner copied to clipboard
QueryDesigner provides way of creating complex IQueryable filtering based on dynamic expression trees.
In where filters seem is key sensitive. How resolve this ?
Give the option to define some global options, for all queries, type MaxPageSize, etc. Example: ``` FilterSettings.Configure(opts => { opts.MaxTop = 1000; opts.PageSize = 20; });. ``` Like: Community.OData.Linq: https://github.com/IharYakimush/comminity-data-odata-linq/wiki/7.-Configure-OData-at-application-startup...
Some IQueryable implementations don't also natively implement IOrderedQueryable (DbSet, for example), so the initial cast in this method fails. ```csharp var res = (IOrderedQueryable)query; var step = OrderStep.First; if (filters...
Added 5 new filter types with names CountEquals,CountLessThan,CountLessThanOrEqual,CountGreaterThan and CountGreaterThanOrEqual. Also pr inludes filtering for collections methods like .Any(t=>t.Status && t.MaxSpeed>300)
I have edited the codebase in this pull request (#20 ) to cater for this enhancement. Request you to review and merge
This change will allow users to probe deeper than 2 levels of a JSON.
Hi Vladislav, Can you give me an example of the `Any` operator? I'd like to filter on a few items, with id 1,2,3. I'm trying with: new TreeFilter { Field...
Hi @mrxten I am trying to filter with Between operator does not included as FilterType. how can I add it in the library. any help please.
Hi @mrxten, I got error when tried to filter complex types. Could you pls help? Thx. **I'm using Entity Framework:** ``` ``` **Model Classes:** Although your tutorial, I'm using ICollection...
Hello, It will perfect if we can filter some fields. In cases of tables with a lot of fields (> 50), if we can filter to return 2 or 3...