Filters

Add any number of filters in any combination, following these basic steps:

Select from a list of conditions, specific to each database
Select one of the following operators: =, < <=, >, <=, <>, Between, Like and Not Like
Specify the criteria value
Add new condition, and repeat steps 1 to 3 as desired
Click ‘Apply’ to apply filters to the database list above
Saving Filters
1. Click ‘Save’ to save the shown filters as the default filters each time the database is loaded.
2. Click the 'Save Filters Options' drop down and choose 'Save As' to save to the list of filters available in then 'Load Filters Options' list.
Loading Filters
1. Click the 'Load Default Filters' button to load the default filters
2. Click the 'Load Filters Options' button to select from a list including:
  1. Default filters
  2. Initial filters when the form was first opened
  3. List of saved filters

Note: To remove all filters, select ‘Delete’ until no filters are shown, then select ‘Apply’. The entire database will be listed without any filters.

With the 'Like' operator, two wildcards are possible:

%		A substitute for zero or more characters
_		A substitute for exactly one character

ABC%		Lists all models that begin with ‘ABC’
%ABC		Lists all models that end with ‘ABC’
%ABC%		Lists all models that contain ‘ABC’
ABC__%		Lists all models that are minimum 5 characters long and start with ‘ABC’
__ABC		Lists all models that are 5 characters long and end with ‘ABC’

The following example lists all models that begin with the letters ‘ABC’.

The following example lists all motors with a maximum torque rating between 80 and 100 Nm.