1. Searching

Table 1. Operators

EQUAL

α =

Equal to a given value

NOT EQUAL

α ≠

Not equal to a given value

LESS THAN

α <

Less than a given value

LESS THAN OR EQUAL

α ≤

Less than or equal to a given value

GREATER THAN

α >

Greater than a given value

GREATER THAN OR EQUAL

α ≥

Greater than or equal to a given value

BETWEEN EXCLUSIVE

< α <

Between an upper and lower bound, excluding the bounds

BETWEEN

≤ α ≤

Between an upper and lower bound, including the bounds

NOT BETWEEN EXCLUSIVE

≥ α ≥

Not between an upper and lower bound, excluding the bounds

NOT BETWEEN

> α >

Not between an upper and lower bound, including the bounds

IN

α ∈

In a set of values

NOT IN

α ∉

Not in a set of values

Each table has an associated search panel, which can be displayed by using the button highlighted in the screenshot below. This button toggles through the available search panel views; hidden, simple and advanced.

Search

By default, all condition operators are set to EQUAL, to change the operator you must switch to the advanced search panel view, see below.

In the screenshot below we have added a wildcard condition to the Name column, using the % character as a wildcard.

Note
The condition is automatically enabled when a value has been entered.

When the search condition has changed, as in, when it does not represent the data currently in the table, the refresh button in the lower left corner becomes enabled, indicating that a refresh is in order. Further column conditions can be added before a refresh is performed.

Search

There are multiple ways of refreshing the table:

  • Pressing the Enter key with the focus somewhere on a column condition panel

  • Using the aformentioned refresh button or the F5 keyboard shortcut

  • Using the Refresh action in the table popup menu

  • Using the Refresh button on the input panel, if one is available, or its Alt+R keyboard shortcut

After the table has been refreshed, the refresh button becomes disabled, indicating that the table data represents the current search condition.

Note
You can tell a condition is enabled by its BOLD header and shaded column.
Search

Adding a condition to the Genre column.

With multiple conditions enabled, all of them are included next time the table is refreshed.

Search

Enabling the advanced condition panel view, in order to change the Name condition to NOT EQUAL.

Search

Adding a LESS THAN condition to the Price column.

Search

Changing the Price condition to GREATER THAN OR EQUAL.

Search

Changing the Price condition to BETWEEN and the Genre condition to NOT EQUAL.

Search

Adding a NOT EQUAL condition to the Composer column with an empty value.

Search
Note
When searching for empty values, the condition must be manually enabled, since it’s only enabled automatically when a non-empty value is entered.
Note
To clear all column conditions use the SearchClear action in the table popup menu. This clears all values and resets all operators to EQUAL.

2. Keyboard shortcuts

Navigation

Ctrl+Alt+↑/↓

Navigate up/down

Ctrl+Alt+←/→

Navigate left/right

Resizing

Shift+Alt+←/→

Resize left/right

Ctrl+Shift+Alt+SHIFT+←/→

Expand/collapse

Ctrl+Alt+E

Toggle edit panel

Transfer focus

Ctrl+E

Edit panel (initial focus component)

Ctrl+T

Table

Ctrl+I

Input field

Ctrl+S

Search field

Ctrl+F

Find in table

Edit panel

Enter

Transfer focus to the next input field

Shift+Enter

Transfer focus to the previous input field

Alt+A

Add

Alt+S

Save (when available)

Alt+U

Update

Alt+D

Delete

Alt+C

Clear

Alt+R

Refresh

Table panel

Insert

Add new item

Ctrl+Insert

Edit selected item

Shift+Insert

Edit selected items

Del

Delete selected

Ctrl+C

Copy selected rows to clipboard

Ctrl+Alt+C

Copy selected cell to clipboard

Ctrl+Shift+←/→

Move selected column

Ctrl++/−

Resize selected column

Alt+Shift+↑/↓

Move selection

Ctrl+G

Show popup menu

Ctrl+P

Print (if available)

Alt+R

Refresh

F5

Refresh, when condition panel is visible and button is enabled

Ctrl+Alt+S

Toggle condition panel between hidden, visible and advanced

Ctrl+S

Select condition panel

Ctrl+Alt+F

Toggle filter panel between hidden, visible and advanced

Ctrl+Shift+F

Select filter panel

Alt+

Toggle sorting by selected column

Alt+

Toggle and add sorting by selected column

Table condition panel

Ctrl+↓/↑

Previous/next search operator

Ctrol+Enter

Enable/disable column condition

Enter

Refresh table data

Table search field

Enter or ↓

Find next

Shift+Enter or ↓

Find and select next

Find previous

Shift+

Find and select previous

Esc

Move focus to table

Date/time field

Insert

Display calendar

↑/↓

Increment/decrement based to cursor position

Calendar

Ctrl+↓/↑

Previous/next year

Shift+↓/↑

Previous/next month

←/→

Previous/next day

↑/↓

Previous/next week

Shift+Alt+↓/↑

Previous/next hour

Ctrl+Alt+↓/↑

Previous/next minute

Entity field (combo box or search field) with Add and/or Edit controls

Insert

Add new item

Ctrl+Insert

Edit selected item

Text input panel

Insert

Display multi-line input dialog

Viewing dependencies

Ctrl+Alt+←/→

Navigate left/right