Slicers display filters on report canvas for easier access. Help filter by hidden columns and create focused reports. Cannot support input fields or drill-down options
WHERE and HAVING clauses are fundamental to SQL SELECT command. Both clauses act as filters to remove records that don't meet criteria. WHERE filters at record level, HAVING filters at group level
Criteria are logical expressions returning TRUE/FALSE or 1/0. Criteria direct logical flow and filter data in formulas. Criteria must return TRUE only when test matches exactly
WHERE clause filters rows in SELECT, UPDATE and DELETE statements. Arguments evaluate to true or false for each row. Multiple arguments can be combined using AND and OR operators
Press Ctrl+Shift+L to remove filters from selected data. Ctrl+Shift+L to undo filters before removing them. Keyboard shortcuts work only with filters applied to data
Web-based tool for filtering OpenStreetMap data using Overpass API. Maintained by Martin Raifer with source code on GitHub. Works with Opera, Chrome and Firefox browsers