NReco QueryBuilder MVC Example

List Filter based on JQuery QueryBuilder plugin

Filter

This ASP.NET MVC example illustrates how to use jQuery QueryBuilder plugin as advanced filter for the data list. Backend uses NReco.Data library for generating SQL WHERE by builder state and executing SQL command. Result may be mapped to the EF models if needed.
Example code is applicable for MVC Core project too.
Order # Company Contact Country Order Date Product Unit Price Quantity
10248 Vins et alcools Chevalier Paul Henriot France 7/4/1996 Queso Cabrales 14 12
10248 Vins et alcools Chevalier Paul Henriot France 7/4/1996 Singaporean Hokkien Fried Mee 9.8 10
10248 Vins et alcools Chevalier Paul Henriot France 7/4/1996 Mozzarella di Giovanni 34.8 5
10249 Toms Spezialitäten Karin Josephs Germany 7/5/1996 Tofu 18.6 9
10249 Toms Spezialitäten Karin Josephs Germany 7/5/1996 Manjimup Dried Apples 42.4 40
10250 Hanari Carnes Mario Pontes Brazil 7/8/1996 Jack's New England Clam Chowagere 7.7 10
10250 Hanari Carnes Mario Pontes Brazil 7/8/1996 Manjimup Dried Apples 42.4 35
10250 Hanari Carnes Mario Pontes Brazil 7/8/1996 Louisiana Fiery Hot Pepper Sauce 16.8 15
10251 Victuailles en stock Mary Saveley France 7/8/1996 Gustaf's Knäckebröd 16.8 6
10251 Victuailles en stock Mary Saveley France 7/8/1996 Ravioli Angelo 15.6 15
10251 Victuailles en stock Mary Saveley France 7/8/1996 Louisiana Fiery Hot Pepper Sauce 16.8 20
10252 Suprêmes délices Pascale Cartrain Belgium 7/9/1996 new name of product 20: 2921 64.8 40
10252 Suprêmes délices Pascale Cartrain Belgium 7/9/1996 Geitost 2 25
10252 Suprêmes délices Pascale Cartrain Belgium 7/9/1996 Camembert Pierrot 27.2 40
10253 Hanari Carnes Mario Pontes Brazil 7/10/1996 Gorgonzola Telino 10 20
10253 Hanari Carnes Mario Pontes Brazil 7/10/1996 Chartreuse verte 14.4 42
10253 Hanari Carnes Mario Pontes Brazil 7/10/1996 Maxilaku 16 40
10254 Chop-suey Chinese Yang Wang Switzerland 7/11/1996 Guaraná Fantástica 3.6 15
10254 Chop-suey Chinese Yang Wang Switzerland 7/11/1996 Pâté chinois 19.2 21
10254 Chop-suey Chinese Yang Wang Switzerland 7/11/1996 Longlife Tofu 8 21
This example is a part of NReco QueryBuilder commercial package. You can purchase it and integrate data filters like that into your ASP.NET project.
Get more information about NReco QueryBuilder for ASP.NET