Sunday, May 18, 2014

Filter

click on image to view

The Filter (Search) form can be temporarily stretched by dragging the right edge.

The Part's Filter is an intelligent cascaded sorting filter, which uses up to 3 search conditions with top down sorting.

Note: Sorted Filtering is applied AFTER the Apply Button is selected.

You can use wild cards (asterisks) and drop down lists or any combination of both.

Example wild card searches:

CAP* Starts with CAP 
*1K* Contains 1K
*SOT23-5 Ends with SOT23-5
?* Parts that do not have empty (blank) fields
1K Exact Value example

Command Buttons: (Left to Right)

Export - Filtered records to Excel.
SQL Query - Opens the SQL Query Dialog.
Default - Resets the Fields and Values to Defaults. (The Defaults can be customized)
Save - Saves the current Filter settings.
Recall - Recalls the saved Filter settings.
Clear Filter - Displays all records in the Parts Table and initializes the user inputs.
Apply - Searches and Sorts the Parts Database.

Tip 1: Wild card ** searches include records with Empty (Blank) data..

Contact Parts to request technical support or a Free online demonstration.

That's it.


No comments: