Filtering & Checklist Queries

dtsmartr provides powerful column filtering tools, from quick checkboxes to complex logical query rules.

1. Column Quick Filters

Click the filter funnel icon inside any column header to open the column quick-filter panel: - Categorical & Low Cardinality Columns: Columns with 20 or fewer unique values show a checklist. Search values dynamically, check the categories you want, and click Apply (or press Enter) to filter. - Continuous / Numeric Columns: Shows a text search input box. Type your filter query and press Enter to instantly filter matching values.


2. Advanced Filter Side-Panel Drawer

Click the Advanced Filter funnel button in the toolbar (or press Ctrl + Alt + F) to slide open the Advanced Query Builder drawer on the right side of the screen: - Rule Groups: Create nested logical conditions using AND or OR connector groups. - Rules: Set complex column rules (operators like equals, contains, in, greater than, is null, etc.). - Live Preview Highlighting: As you edit rules in the sidebar, matching rows are immediately highlighted in yellow in the table behind it, providing real-time visual feedback before you commit the query. - Live Count: Shows the matching row count in real-time. - Click Apply Query to filter, or click the refresh/clear button to reset.

3. Live Interactive Filtering Example

Try searching or filtering columns in the live grid below:

library(dtsmartr)
dtsmartr(mtcars)