Filtering & Sorting

M
Written By Melih SünbülLast updated 5 months ago

Finding the right data shouldn't require a database query. Lex App's grid lets you filter and sort visually — click, type, select — and the results update instantly.

Column Filters

Every column header has a built-in filter. Click the menu icon on any column to open its filter panel. The filter type adapts to the data:

Column Type

Filter Style

Example

Text

Contains, starts with, equals, not equals

Find expenses where description contains "travel"

Number

Contains, equals, not equals, blank, not blank

Find amounts matching "5000"

Date

Before, after, between, exact date, blank, not blank

Expenses after January 1, 2026

Boolean

True / False / All

Show only approved expenses

Foreign Key

Dropdown of related records

Filter by a specific team or employee

🎬 Video — Column filtering in action
🎬 Watch video
Open a column filter on the Amount column, type a value to filter, see the grid update instantly.

Text Filters

For text columns, simply start typing in the filter input. The grid filters as you type — no need to press Enter. You can also use the condition dropdown for more specific matches:

  • Contains — the default; matches anywhere in the text
  • Starts with — useful for codes or identifiers
  • Equals — exact match only
  • Not equal — exclude specific values
  • Blank / Not blank — find missing data

Date Filters

Date columns use a calendar picker for precision. Select a range with "between" to isolate a specific period — like all expenses from Q1 2026. The built-in date picker handles timezones automatically.

<!-- 📸 SCREENSHOT: Date filter open showing a date range selection -->

Foreign Key Filters

When a column references another model (like an Employee's Team), the filter shows a searchable dropdown of all related records. Select one or more to narrow the view.

<!-- 📸 SCREENSHOT: Foreign key filter dropdown showing a list of teams -->

Multi-Column Sorting

Click any column header to sort by that column. Click again to reverse the order. A small arrow indicator shows the current sort direction.

For multi-column sorting, hold Shift and click additional columns. This creates a sort priority chain — for example, sort by Team first, then by Amount within each team.

Sort Order

Column

Direction

1st

Team

A → Z

2nd

Amount

High → Low

3rd

Date

Newest first

The sort indicators show the priority number next to each sorted column header.

To clear all sorting, right-click any column header and select Reset Columns from the context menu.

Combining Filters

Filters stack. Apply a date filter, then a category filter, then sort by amount — each filter narrows the dataset further. The grid shows the total visible row count in the status bar, so you always know how much data you're looking at.

This is especially powerful with saved views: set up a complex filter combination once, save it, and switch to it instantly whenever you need it.

🎬 Video — Building a multi-filter view
🎬 Watch video
Build up a view step by step: apply a date range, then category filter, then sort by amount.

Was this helpful?

Your feedback shapes what we write next.