-
Data Grids / Data Management
-
Data Grid
- Overview
-
Data Binding
-
Filtering
- Sorting
-
Editing
-
Grouping
-
Selection
- Focused Row
- Paging
-
Scrolling
-
Columns
-
Master-Detail
-
Data Summaries
-
Drag & Drop
-
Export to PDF
-
Export to Excel
- Appearance
-
Customization
- State Persistence
-
Adaptability
-
Keyboard Navigation
- Right-To-Left Support
-
Tree List
- Overview
-
Data Binding
-
Filtering
- Sorting
-
Editing
-
Selection
- Focused Row
- Paging
-
Columns
- Drag & Drop
- State Persistence
- Adaptability
-
Keyboard Navigation
-
Card View
-
Pivot Grid
- Overview
-
Data Binding
-
Field Management
-
Data Summaries
- Drill Down
- Filtering
-
Scrolling
-
Export to Excel
- Chart Integration
- Customization
- State Persistence
-
Filter Builder
-
-
Data Visualization
-
Charts
- Overview
-
Data Binding
-
Common Concepts
-
Axis
-
Aggregation
-
Tooltips
-
Selection
-
Customization
-
Zooming
-
Export
-
-
Area Charts
-
Bar Charts
- Bullet Charts
-
Doughnut Charts
-
Financial Charts
-
Funnel and Pyramid Charts
-
Line Charts
- Pareto Chart
-
Pie Charts
-
Point Charts
-
Polar and Radar Charts
-
Range Charts
- Sankey Chart
-
Sparkline Charts
-
Tree Map
-
Gauges
- Overview
-
Runtime update
-
Bar Gauge
-
Circular Gauge
-
Linear Gauge
-
Diagram
- Overview
-
Data Binding
-
Featured Shapes
-
Custom Shapes
-
Document Capabilities
-
User Interaction
- UI Customization
- Adaptability
-
-
Scheduling / Planning
-
Scheduler
- Overview
-
Data Binding
-
Views
-
Appointments
-
Timetable
- Editing
-
Grouping
- Virtual Scrolling
- Drag & Drop
-
Customization
- Adaptability
-
Gantt
- Overview
- Data Binding
-
Filtering
- Sorting
- Strip Lines
- Export to PDF
- Validation
-
Customization
-
-
Messaging
-
WYSIWYG Editor
-
Forms
-
Data Editors
- Overview
-
Common Concepts
-
Calendar
- Check Box
- Color Box
- Date Box
-
Date Range Box
-
Number Box
- Radio Group
-
Range Selector
- Range Slider
- Slider
- Switch
- Text Area
- Text Box
-
Drop-Downs
- Autocomplete
-
Drop Down Box
-
Select Box
-
Tag Box
-
Lookup
-
Buttons
-
File Upload / File Management
-
File Manager
- Overview
-
File System Types
-
Customization
-
File Uploader
-
-
Popup and Notifications
-
Navigation
- Overview
- Accordion
-
Context Menu
-
Menu
- Multi View
-
Drawer
-
Tab Panel
-
Tabs
-
Toolbar
-
Stepper
- Pagination
-
List
-
Tree View
- Right-to-Left Support
-
Layout
-
Tile View
- Splitter
-
Gallery
- Scroll View
-
-
Interactive Wrappers
-
Sortable
- Resizable
-
-
Progress Indicators
-
Maps
- Overview
-
Map
-
Vector Map
-
Data Binding
- Multiple Layers
-
Markers
- Legend
-
Zooming and Panning
-
Customization
-
-
Localization
Related Demos:
Your search did not match any results.
Filter Builder - Customization
In this demo, a custom filter operation, "anyof", is implemented. The calculateFilterExpression function converts it into DataSource-compatible operations. The compatible and incompatible filter expressions are displayed under the FilterBuilder.
The set of available group operations is limited to "and" and "or" using the groupOperations array, and the groups’ maximum nesting level is limited to one using the maxGroupLevel.
Was this demo helpful?
Feel free to share demo-related thoughts here.
If you have technical questions, please create a support ticket in the DevExpress Support Center.
Thank you for the feedback!
If you have technical questions, please create a support ticket in the DevExpress Support Center.
Backend API
@{
var value = new object[] {
new object[] { "Category", "anyof", new[] { "Automation", "Monitors" } },
"or",
new object[] {
new object[] { "Category", FilterBuilderFieldFilterOperations.Equal, "Televisions" },
"and",
new object[] { "Price", "between", new[] { 2000, 4000 } }
}
};
var categories = new[] {
"Video Players",
"Televisions",
"Monitors",
"Projectors",
"Automation"
};
}
@(Html.DevExtreme().FilterBuilder()
.ID("filterBuilder")
.Fields(fields => {
fields.Add().DataField("Name");
fields.Add().DataField("Price")
.DataType(FilterBuilderFieldDataType.Number)
.Format(Format.Currency);
fields.Add().DataField("CurrentInventory")
.DataType(FilterBuilderFieldDataType.Number)
.Caption("Inventory");
fields.Add().DataField("Category")
.FilterOperations(new[] { "=", "anyof" })
.Lookup(l => l.DataSource(categories));
})
.Value(value)
.MaxGroupLevel(1)
.GroupOperations(new[] {
FilterBuilderGroupOperations.And,
FilterBuilderGroupOperations.Or
})
.OnValueChanged("filterBuilder_updateTexts")
.OnInitialized("filterBuilder_updateTexts")
.CustomOperations(o => {
o.Add()
.Name("anyof")
.Caption("Is any of")
.Icon("check")
.EditorTemplate(@<text>@(
Html.DevExtreme().TagBox()
.Value(new JS("value"))
.InputAttr("aria-label", "Category")
.Items(categories)
.OnValueChanged(@"function(e) {
setValue(e.value && e.value.length ? e.value : null);
}")
.Width("auto")
)</text>)
.CalculateFilterExpression("tagBox_calculateFilterExpression");
})
)
<div class="results">
<div>
<b>Value</b>
<pre id="filterText"></pre>
</div>
<div>
<b>DataSource's filter expression</b>
<pre id="dataSourceText"></pre>
</div>
</div>
<script>
function tagBox_calculateFilterExpression(filterValue, field) {
return filterValue && filterValue.length
&& Array.prototype.concat.apply([], filterValue.map(function (value) {
return [[field.dataField, "=", value], "or"];
})).slice(0, -1);
}
function filterBuilder_updateTexts(e) {
$("#filterText").text(formatValue(e.component.option("value")));
$("#dataSourceText").text(formatValue(e.component.getFilterExpression()));
}
function formatValue(value, spaces) {
if (value && Array.isArray(value[0])) {
var TAB_SIZE = 4;
spaces = spaces || TAB_SIZE;
return "[" + getLineBreak(spaces) + value.map(function (item) {
return Array.isArray(item[0]) ? formatValue(item, spaces + TAB_SIZE) : JSON.stringify(item);
}).join("," + getLineBreak(spaces)) + getLineBreak(spaces - TAB_SIZE) + "]";
}
return JSON.stringify(value);
}
function getLineBreak(spaces) {
return "\r\n" + new Array(spaces + 1).join(" ");
}
</script>
using System.Web.Mvc;
using DevExtreme.MVC.Demos.Models.SampleData;
namespace DevExtreme.MVC.Demos.Controllers {
public class FilterBuilderController : Controller {
public ActionResult Customization() {
return View();
}
}
}
.results {
margin-top: 50px;
display: flex;
justify-content: space-between;
}
.results > div {
flex-basis: 49%;
max-width: 50%;
background-color: rgba(191, 191, 191, 0.15);
position: relative;
}
.results b {
position: absolute;
top: -25px;
}
.results pre {
padding: 10px 20px;
height: 100%;
font-size: 13px;
overflow: auto;
box-sizing: border-box;
}
.dx-tagbox {
min-width: 150px;
}
.dx-filterbuilder {
background-color: transparent;
box-shadow: 0 8px 16px 0 rgba(0, 0, 0, 0.14), 0 0 2px 0 rgba(0, 0, 0, 0.12);
border-radius: 6px;
padding: 15px;
}
.dx-filterbuilder .dx-numberbox {
width: 80px;
}