Use filters to isolate key selection criteria.  Add any number of filters in any combination, following these basic steps:

1. Select from a list of conditions, specific to each database
2. Select one of the following operators: =, < <=, >, <=, <>, Between and Like
3. Specify the criteria value
4. Add new condition, and repeat steps 1 to 3 as desired
5. Click ‘Apply’ to apply filters to the database list above
6. Click ‘Save’ to save the shown filters as the default filters each time the database is loaded.

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

The ‘Like’ Operator and the ‘%’ Symbol

ABC%         => Lists all models that begin with ‘ABC’
%ABC         => Lists all models that end with ‘ABC’
%ABC%      => Lists all models that contain ‘ABC’

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

 

The ‘Between’ Operator

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

Related topics

  Databases