Using Lists and Searching on ColorPoint Console

 

The Formula and Job pages of CPC have the facility to navigate through their lists an item at a time, a page at a time and by searching the codes or names of the items.

Navigating

To the right of the lists on the job and formula pages are the navigation buttons.

From top to bottom they are:

• Previous item
• Previous page
• Next page
• Next item

The navigation buttons “wrap around”. So pressing the previous page button when on the first page will take you to the last page and pressing previous item when on the first item will take you to the last item. Similarly, next page or item on the last page or item will take you to the first.

Searching

The main buttons to use when searching are these:

The left button is “Search”, the right button is “Clear Search”. Pressing “Clear Search” at any time reverts the list to all jobs or formulas in the database.

Pressing “Search” takes you to the search page.

Pressing the “? Code” or “? Name” button toggles between searching in the code of name for the text you enter. The search field preference will be remembered for your next search.

The text you enter is searched for anywhere in the code or name field. So typing “12” would match formulas “12”, “120”, “0012” and “ABC 12”.

Pressing the “Clear” button clears the search text.

On the left the button allows you to step through the list of your last 10 searches allowing frequently used searches to be re-used without re-typing them.

The counter in the centre of the screen shows how many records will be returned by your current search. When you have narrowed the number of results returned down, press the select button to apply your search to the list.

 

 

 

Filtering and the Filter Panel on ColorPoint Manager

 

The filter panel is one of the most powerful parts of CPM. Using the various search fields it is possible to narrow down a large list of items to a small selection making it easy to find individual items.

Basic Filtering

To display the filter panel click the ‘Filter’ button on the navigation toolbar:

Here is a list of materials, unfiltered:

Typing ‘m’ into the code entry area of the filter panel filters the list to any codes that contain the letter m, in upper or lower case anywhere in the code:

This has removed the entry ‘BN1’ from the list.

Expanding the search further to filter on items containing ‘m1’ results in the following list:

Reverse Filtering

Changing the search type from ‘Like’ to ‘Not Like’ reverses the search, showing only items that do not contain an ‘m’.

Exact Matches

Changing the search type from ‘Like’ to ‘=’ changes the result to an exact match only.

Matching Ranges

Finally, a range of items may be searched by entering the starting search, in this case ‘a’, pressing the ‘To’ button and then entering the ending search. Please note the search excludes the last item in the search range, so that searching ‘a’ to ‘c’ gives items beginning with ‘a’ and ‘b’, but not c.

Checking the Exclude box reverse the search and removes these items from the results:

The same principles apply to searching across date ranges, price ranges and dispense weight ranges.