Advanced Filtering in List View

Use Advanced Filtering to explore large datasets without opening each record.

Open Advanced Filtering

1. Open any DocType list view.
2. Click Add filter.
3. Choose a field, operator, and value.

You can add multiple rows to combine conditions.

Filter Operators

Operator	Meaning	Example
Equals (eq)	Exact match	status = Open
Greater Than (gt)	Numeric/date value is higher	amount > 100
Less Than (lt)	Numeric/date value is lower	amount < 1000
In (in)	Match any value in a list	priority in High, Urgent
Like (like)	Partial text match	title like INV

Notes

• For In, enter comma-separated values like High, Urgent, Critical.
• For Like, enter plain text; the Desk automatically applies wildcard matching.

Manage Filter Rows

• Click Add filter to add another row.
• Click Remove filter N to remove a specific row.
• Click Clear filters to reset everything.

Column Management

Use Columns to customize what you see:

1. Click Columns.
2. Toggle columns on or off.
3. Set a width for important columns.

Column visibility and width are saved per DocType in browser storage.

Metadata-Defined Defaults

List view now defaults to ui_meta.list_columns (and supports ui_meta.list.columns).

If no list columns are defined, the list falls back to the name field for a focused default view.