BraDypUS

Appearance

Search & filter ​

BraDypUS offers three search modes, all accessible from the DataView toolbar.

Type in the search bar at the top of the record list. The query is matched against all preview fields using a case-insensitive LIKE search.

TODO_SCREENSHOT: DataView with text typed in the fast-search bar and filtered results in the list

Fast search is designed for quick lookups. For more precise filtering use Advanced search.

Click Advanced in the toolbar to open the filter builder. Each row defines one condition:

ColumnDescription
FieldAny field from the table or its plugin tables
OperatorHow to compare (see table below)
ValueThe value to compare against
ConnectorAND / OR — how this row combines with the next

TODO_SCREENSHOT: Advanced search panel with two filter rows visible, each with a field dropdown and operator

Operators ​

OperatorMeaning
containsField value contains the text (case-insensitive)
is exactlyExact match
does not containField value does not contain the text
starts withField value starts with the text
ends withField value ends with the text
is emptyField is NULL or empty string
is not emptyField has a non-empty value
>Greater than (numeric or date)
<Less than (numeric or date)

Add rows with Add condition and remove them with the trash icon. Click Search to apply. Click Reset to clear all filters.

Click SQL in the toolbar to enter a raw SQL WHERE clause. This mode is available to admin users only.

sql
sigla LIKE 'US%' AND periodo = 'Basso Medioevo'

TODO_SCREENSHOT: SQL expert search panel with a raw SQL clause typed in the input box

WARNING

SQL expert search is powerful but bypasses the field-level validation. Only use it if you know the exact column names and value formats.

Persistent filters ​

The active filter is stored in the URL as a query parameter. Copying the URL and sharing it (or using Back/Forward in the browser) restores the exact search state.

The Harris Matrix and Geoface views inherit the active filter from DataView — the matrix or map will show only the records that match the current filter.

Advanced search lets you filter by fields in plugin tables as well as the main table. Plugin fields are listed under a labelled group in the field dropdown.

Searching reference fields ​

Fields that point to another table (configured with id_from_tb) store the id of the referenced record, but you search them by the referenced table's display value: the autocomplete suggests those values, and the search resolves them through the referenced table automatically. This works for reference fields of the main table and of its plugin tables alike.