Data Management

Filtering and Searching

Filtering And Searching

WhoDB has two different data-finding tools on a storage unit data page.

Visible-Row Search

The Search input looks through rows currently loaded in the grid.

Typing calls the grid search helper immediately.
Matching cells are scrolled into view and temporarily highlighted.
Repeating the same search advances through matches.
Use it for quick lookup in the rows already visible.
Use WHERE conditions for SQL WHERE clauses.
Move through pages or raise the page size when you need to search more loaded rows.

Where Conditions

Use Where condition when you need the database to filter rows.

Open Conditions

Click the Add button under Where condition to open the condition popover. Existing conditions appear as badges next to the button, with a "+N more" button once more than two exist. An alternative sheet mode, which opens conditions in a side panel, can be enabled in Settings.

Choose Field Operator Value

Select a field, select an operator, and enter a value.

Add The Condition

Click Add Condition inside the condition sheet or popover.

Run The Query

Click Query on the data page. This reloads rows using the saved conditions.

Multiple Conditions

Current CE conditions are combined with AND logic. Existing conditions can be edited or removed from the condition sheet.

When To Use Each Tool

Need	Use
Jump to a value in the visible grid	Search
Filter millions of rows in the database	Where condition + Query
Export a filtered result set	Apply Where conditions, click Query, then export
Find values on a later page	Change page or use a Where condition

Deleting Records

Sorting and Pagination