The hardware and bandwidth for this mirror is donated by dogado GmbH, the Webhosting and Full Service-Cloud Provider. Check out our Wordpress Tutorial.
If you wish to report a bug, or if you are interested in having us mirror your free-software or open-source project, please feel free to contact us at mirror[@]dogado.de.

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)

These binaries (installable software) and packages are in development.
They may not be fully stable and should be used with caution. We make no claims about them.
Health stats visible at Monitor.