Skip to content
Mathesar Wiki
Filters Inspiration
Initializing search
mathesar-foundation/mathesar-wiki
Mathesar Wiki
mathesar-foundation/mathesar-wiki
Home
Community
Community
GitHub
Mailing lists
Matrix
Discord
GSoC
GSoC
Applicant Guide
Mentee Guide
Mentor Guide
Project Idea Template
Project ideas
Project ideas
API documentation
Archived Project Ideas from GSoC 2022
Automatically suggest improvements to table normalization
Automatic Hint Reflection
Break Columns out to New Table
Support Data Export
Database Views
Construct Dependency Graph for Database Objects
Support for File & Image Data Types
Support Importing Data into Existing Tables
Support importing Excel and JSON files
Support for JSON Data Type
JSON editor
Kanban View
List data type
Location Data type
Make casting functions inlinable
Support More Data Import Sources
Add more summarization functions
Persist UI configuration
Phone Number data type
Support for PostGIS Data Types
Sharable Forms to Add Data to Tables
Single Select "data type"
Suggest Candidate Columns to Create Separate Table
Better Support for Default PostgreSQL Data Types
UI for Importing data into existing table
Visualization of Grouped Data
Implement Textual SQL Query Builder
Project Proposal Template
Mentor summit notes
Mentor summit notes
GSoC proposal phase session minutes
Proposal phase gsoc summit session notes
Previous Projects
Previous Projects
2022
2022
GSoC 2022: Dependents graph
GSoC 2022: Importing data into existing tables
GSoC 2022: JSON data type
2023
2023
List data type report - 2023 internship
Events
Events
2022-01-02 Code for Japan Social Hack Day
Office Hours (2022-03-21 to 2022-03-25)
Office Hours (2022-03-28 to 2022-03-31)
Office Hours (2022-04-04 to 2022-04-08)
Office Hours (2022-04-12 to 2022-04-15)
Office Hours (2023-03-27 to 2023-03-29)
Team
Team
Responsibilities
Responsibilities
Fundraising
GSoC 2023
Marketing
Product management
Repo administration
Team management
User feedback tracking
User help
Guide
Guide
Communication
Events
Issues
Meetings
Tools
Workflow
Worklogs
Worklogs
Anish's work log
Brent's work log
Ghislaine's work log
Kriti's work log
Pavish's work log
Sean's work log
Archive
Archive
Dom's work log
Mukesh work log
Rajat's work log
2023 07
2023 07
Anish's work log archive: 2023-07
Brent's work log archive: 2023-07
Ghislaine's work log archive: 2023-07
Kriti's work log archive: 2023-07
Pavish's work log archive: 2023-07
Rajat's work log archive 2023-07
2023 08
2023 08
Anish's work log archive: 2023-08
Brent's work log archive: 2023-08
Ghislaine's work log
Kriti's work log archive: 2023-08
Pavish's work log archive: 2023-08
Rajat's work log archive 2023-08
2023 09
2023 09
Anish's work log archive: 2023-09
Brent's work log archive: 2023-09
Ghislaine's work log
Kriti's work log archive: 2023-09
Pavish's work log archive: 2023-09
Rajat's work log archive: 2023-09
2023 10
2023 10
Anish's work log archive: 2023-10
Brent's work log archive: 2023-10
Ghislaine's work log
Kriti's work log archive: 2023-10
Pavish's work log archive: 2023-10
Meetings
Meetings
2021
2021
04
04
April 2021 meeting notes
05
05
May 2021 meeting notes
06
06
June 2021 meeting notes
07
07
July 2021 meeting notes
08
08
August 2021 meeting notes
09
09
September 2021 meeting notes
10
10
October 2021 meeting notes
11
11
November 2021 meeting notes
12
12
December 2021 meeting notes
2022
2022
01
01
January 2022 meeting notes
02
02
February 2022 meeting notes
03
03
March 2022 meeting notes
04
04
April 2022 meeting notes
05
05
May 2022 meeting notes
06
06
June 2022 meeting notes
07
07
July 2022 meeting notes
08
08
August 2022 meeting notes
09
09
September 2022 meeting notes
10
10
2022-10-04 backend meeting
2022-10-05 weekly meeting
2022-10-12 weekly meeting
2022-10-19 weekly meeting
2022-10-26 weekly meeting
11
11
2022-11-02
2022-11-09 weekly meeting
2022-11-17 weekly meeting
2022-11-28 planning meeting
2023
2023
01
01
2022-01-05 release planning meeting
2023-01-18 Frontend meeting on RFCs
2023-01-20-partial-user-input-of-dates
02
02
2023-02-01 Team Meeting
2023-02-08 launch planning meeting
2023-02-10 launch check-in
2023-02-13 launch check-in
2023-02-15 launch check in
2023-02-17 launch check in
2023-02-21 launch check in
2023-02-22 launch check-in
2023-02-23 launch check in
2023-02-24 launch update email
2023-02-27 deployment check-in
03
03
2023-03-02 launch check-in
2023-03-07 priorities & workflow meeting
Removing SQLAlchemy meeting 2023-03-08
2023-03-13 backend meeting
2023-03-15 core team meeting
Core team meeting 2023-03-17
Installation Improvements Meeting
Handling regressions in 0.1.1
2023-03-21 Plan for 0.1.2
Installation improvements planned for 0.1.2
2023-03-29 Team meeting
04
04
2023-04-03 Installation plan finalization
05
05
2023-05-03 Team meeting
2023-05-10 Team meeting
2023-05-30 Front End Team meeting
06
06
2023-06-07 team meeting
2023-06-13 Installation Planning Meeting
2023-06-27 team meeting
07
07
2023-07-03 team meeting
2023-07-06 installation planning meeting
2023-07-06 team meeting
2023-07-11 installation meeting
2023-07-26 team meeting
2023-07-28 installation meeting
08
08
2023-08-09 team meeting
2023-08-10 team meeting
2023-08-18 Team meeting
2023 08 23 team meeting
09
09
2023-09-06 team meeting
2023-09-27 team meeting
User CRM and Interviews
10
10
2023-10-03 User Feedback meeting
2023-10-05 team meeting
2023-10-10 Phase 1 finalization call with Kriti
2023-10-10 User Feedback meeting
2023-10-17 User Feedback Meeting
11
11
2023-11-17 Design Session
2023-11-08 Team meeting
2023-11-22 staff check in
12
12
2023-12-01 Design Session
2023-12-11 staff meeting
2023-12-12 Design Session
2023-12-13 staff meeting
2023-12-14 Product big-picture meeting
2023-12-20 staff meeting
2024
2024
01
01
2024-01-04 staff meeting
2024-01-17 staff meeting
2024-01-18 Product big-picture meeting
2024-01-22 QA testing meeting
2024-01-24 Staff Meeting
2024-01-29 Staff Meeting
2024-01-31 Staff Meeting
02
02
2024-02-08 Product big-picture meeting
2024-02-12 beta planning meeting
2024-02-13 Product big-picture meeting
2024-02-28 release check-in
03
03
2024-03-06 Staff Meeting
2024-03-21 staff meeting
2024-03-27 staff meeting notes
04
04
2024-04-03 staff meeting notes
05
05
2024-05-30 maintainer meeting
06
06
2024-06-04 maintainer meeting
2024-06-18 maintainer meeting
07
07
2024-07-02 maintainer meeting
2024-07-11 maintainer meeting
2024-07-16 maintainer meeting
2024-07-23 maintainer meeting
2024-07-24 permissions retrospective
08
08
2024-08-01 maintainer meeting
2024-08-08 maintainer meeting
2024-08-28 maintainer meeting
2024-08-29 maintainer meeting
09
09
2024-09-18 release planning meeting
Archive
Archive
Comms Assignee
Weekly Discussion
Projects
Projects
2023
2023
04
04
2023-04 Usability Improvements
Formulas Research
Raise additional funding for Mathesar
Gathering User Feedback
Installation Documentation Improvements
Research: Publicly shareable links
Release v0.1.2
Mathesar T-shirt Project
Establish User Feedback Tracking Process
07
07
2023-07 backend fixes
2023-07 Frontend Fixes
2023-07 product strategy
Installation Improvements Project - 0.1.3
Internationalization Implementation
List Data Type - Project Draft
Shareable links Implementation
Move DDL Operations to SQL Functions
08
08
Installation Improvements 0.1.4
Niche research
Investigating compatibility with pre-existing databases
2024
2024
Architecture transition
Architecture transition
Models
Deprecated Models
Users and Permissions
Record summaries
RPC client specs
RPC transition
Future
Future
Avoiding regressions
Column Moving Improvements
Forms Research
Remove SQL Alchemy -- Performance edition
Remove SQLAlchemy from codebase
Move DML Operations to SQL Functions
Remove SQLAlchemy from DQL operations
Template
Product
Product
Feature Ideas
Product Principles
Related Products
Resources
Roadmap
Concepts
Concepts
Data Types
Databases
Filters
Schemas
Tables
Views
Feedback
Feedback
March 2023 product feedback
Specs
Specs
Dynamic Defaults Proto-Spec
Example Schema
Permissions - Revamp
Publicly shareable links
Quick Save Functionality
Users & Permissions
2022 01 views
2022 01 views
01. Assumptions and Limitations
02. Feature Requirements
03. The Query Builder
04. Formulas
05. View Structure
06. View Columns
07. Breaking Down DB Queries
08. Appendix
04 formulas
04 formulas
(a) Record Aggregation Formulas
(b) Random Generators
(c) Text Formulas
(d) Number Formulas
(e) Boolean Formulas
(f) Date, Time, and Duration Formulas
(g) List Formulas
(h) Cumulative Formulas
(i) Regular Expression Formulas
(j) Custom Formulas
Design
Design
Principles
Resources
Standards
Specs
Specs
Formulas
Formula Columns
Adding, Update and Deleting Records
Boolean Data Type
Clipboard Interaction specs
Column Extraction
"Database Connections" Page Design Specs
Create, Edit, Delete Views
Duration Data Type Specs
Data Type Options
Text Data Type
Multiple Database Switching
Date, Time, and DateTime Data Types
Editing Records Within a View
Email Data Type
Filter, Sort, and Group Tables
Usage of Foreign Key Constraints
Global Data Type Components
Import Status
Inline Saving and Editing
Listing Views Spec
Lookup Field Component Specs
Money Data Type Specs
Multiple Records Associated with a Single Record
Navigation Consistency Updates
Navigation Updates
Navigation Updates
"New Database Connection" Form Design Specs
Non-Mathesar Data Types
Number Data Type
Pagination Specs
Read Only Table Spec
Record Page Design
Record selector UX design specs
Record Summary
Working with Schemas
Sidebar Improvements Spec
NULL Value Specs
Table Creation Controls (discard modal update)
Add Table from Import/URI/Data paste Specs
Table Inspector
Basic Table Operations Spec
User Interface Style
URL Data Type
Viewing a View
One-to-Many Relationships
Data Explorer
Working with Columns
Exploration
Exploration
Data Management Skills
Data Types Inspiration
Filters Inspiration
Filters Inspiration
On this page
Advanced Filters
Inventory: Data Exploration
Use Cases
Use cases
Use cases
Inventory Use Case
Process
Process
Deliverables
Design System
Design Review Guidelines
Reports
Reports
Inventory Use Case
Tool Category Exploration
Engineering
Engineering
Specs
Specs
Human Readable Dates and Times
DDL Operations
Dependents graph spec
DML Operations
Import Preview API
Installation Improvement Plan
Internationalization of Mathesar Codebase
List data type - Frontend specs
Number display and entry
Record Selector spec
Syncing Database Objects
Worksheets Technical specs
Glossary
Glossary
Filters in Mathesar
UI Data Types
Code review
Code review
Backend Code Review
Research
Research
Formulas research
Resources
Markdown
Server update process
How tos
How tos
How to migrate from 0.1.7 to 0.2.0-testing.1
How to set up a new GitHub repo
Archive
Archive
Engineering Decisions
Release
Release
Cutting
QA
Release notes
Publishing
Marketing
Marketing
Copy
History
Sites
Jobs
Jobs
Past
Past
2021-04 - Product Designer
2021-04 - Frontend Engineer #1
2021-09 - Frontend Engineer #2
2021-10 - Senior Backend Engineer
2022-05 - Frontend Engineer #3
On this page
Advanced Filters
Filters Inspiration
¶
Advanced Filters
¶
Example of advanced filtering with filter groups.