Use the Filter Builder dialog to set the contents of a filter. At a minimum, a filter must be set up with one row that includes a filter condition (Column, Test, and Value) or a sort (Column and Direction).
You can add more conditions to a filter by adding rows and choosing the Operation that separates them. For a filter with multiple conditions, you can also add parentheses to apply an Operation to a group of filter conditions.
Contents [Hide] |
Click on the Column box.
Then click on the name of the data column for which you want to filter for specific values.
Click on the Test box.
Then select the type of test you want to perform:
Equals looks for data records with values that exactly match the Value you specify.
Doesn't Equal looks for data records with values that are not an exact match to the Value you specify.
Greater Than, Greater or Equal, Less Than, and Less or Equal use a dictionary sort to compare each data record's value to the Value you specify. These tests are not available when the Column on this row is Event, Cause, Action Taken or Bypass.
Contains will check the data record for the Value you specify. If the data record contains this value – with or without additional characters – the data record will pass the filter and be included in your analysis. This test is not available when the Column on this row is Event, Cause, Action Taken or Bypass.
Doesn't Contain will check the data record for the Value you specify. If the data record does not contain this value – with or without additional characters – the data record will pass the filter and be included in your analysis. This test is not available when the Column on this row is Event, Cause, Action Taken or Bypass.
Click on the Value box, and then use one of the options below:
You can enter the value for what you want to filter.
If you are filtering for a partial value, you will probably want to enter that value here and choose the Contains or Doesn't Contain test.
For example: to retrieve data for Machine numbers 1000 - 1009, you could choose the Column of Machine, the Test of Contains, and a Value of 100_ . |
If the Column you selected is a traceability column with a predefined list of values, you can choose one of these values by clicking the arrow at the end of this box.
If the Column you selected is a traceability column, you can also choose from a list of all of the values that exist in this column of your database by clicking the arrow at the end of this box and then choosing Click for current entries. This will change the Value list to display the actual values found in this traceability column in your database. The task of filling the Value list with current entries may be slow if your database is large.
If you want to add more criteria to this filter, go to Adding a Filter Condition and Setting the Operation below.
Otherwise, go to Saving the filter contents to save your filter.
To filter for additional criteria, click Add Filter Condition. This will append a new, blank row for which you can set the Column, Test and Value.
1. Click anywhere in the existing filter condition. 2. Press and hold the CTRL key. 3. Click Add Filter Condition, and then release the CTRL key. |
When you create a filter with more than one filter condition, you should determine which Operation is needed to connect two adjoining filter conditions.
When choosing the Operation, remember that each data record must pass the entire filter.
If two filter conditions will test the same Column, it is typical to connect them with the "OR" operation.
Example: Each data record is evaluated with the test "If the machine contains 1400 or 1500, include this data record in analysis."
If two filter conditions will test different Columns, it is typical to connect them with the "AND" operation.
Example: Each data record is evaluated with the test "If the machine contains 1400 and the Shift contains 3, include this data record in analysis."
If you are creating a filter with both AND and OR operations, it is strongly recommended that you use Parentheses to group together the correct filter conditions.
If you are creating a filter with both AND and OR operations, you should use Parentheses to group together the correct filter conditions.
Take for example the following filter:
Which test will be performed on each data record?
If the machine equals 1400, or if the machine equals 1500 and the shift equals 3, include this data record in the analysis.
If the machine equals 1400 or 1500, and if the shift equals 3, include this data record in the analysis.
It is not completely obvious how data records will be evaluated. And in fact, a filter like the example above will evaluate each data record with the test "If the machine equals 1400, or if the machine equals 1500 and the shift equals 3, include this data record in the analysis."
To be certain about the way that data will be evaluated using this type of filter, use Parentheses to group some criteria together, as in the example below:
With parentheses, it is clear that each data record will be evaluated with the test "If the machine equals 1400 or 1500, and if the shift equals 3, include this data record in the analysis."
To add parentheses, click the arrow in the ( or ) box to select how many parentheses you need.
When GainSeeker retrieves data records, they are typically sorted first by Part Number / Process and then by date/time stamp.
To set a different sort order, choose the Column you want to sort by and the Direction for the sort (Ascending or Descending).
To add another level to the sort, click Add Sort. In the new Then by row, choose the next Column you want to sort by the Direction for this next level of the sort.
Example: First, data records will be sorted by Shift in ascending order (e.g., Shift 1, then Shift 2, etc.).
Then within each Shift, all of the records reported for that Shift will be sorted by Machine in ascending order (e.g., Machine A, Machine B, etc.)
The sort order of the resulting data will be similar to the following:
Shift 1 / Machine A
Shift 1 / Machine B
...
Shift 2 / Machine A
Shift 2 / Machine B
...
You can apply two or more filters to the same data using the Combine filters feature on the Select Filters dialog.
When you apply sort options to filters you combine, GainSeeker generates the data by the sort you chose for the filter label that lists first in the alphabetical listing on the Select Filters dialog box. GainSeeker next generates the data by the sort (if applicable) for the next filter you want to combine—the selected filter label that comes next in the alphabet.
For example, you might opt to combine the filters Line and Shift. You also opted to sort the Line filter column by Operator, and the Shift filter column by Machine. The resulting data for this example will first sort by Operator and then by Machine. That is because Line lists before Shift in the alphabet, giving the sort by Line (Operator) precedence over the sort selected for Shift (Machine).
Additional notes:
The alphabetical ordering of the filter labels applies regardless of the number of filters you choose to combine.
If you would want the Sort by selection for Shift to be performed before the Sort by selection for Line, you could change the label (name) for the Shift filter so that it alphabetically precedes the Line filter label. For example, you could relabel the Shift filter as "a-Shift" to move it up on the alphabetized list or relabel Line as "z-Line" to move it down on the list. Either action would reorder the manner in which GainSeeker displays the data.
If you select the same Sort by option for two or more filters you combine,no data will be retrieved. If combined filters Line and Shift both have the Sort by option set to Operator, for example, no data will be retrieved.
Using the example above, you could opt to display the sort in ascending order for one filter (Line - sorted by Operator) while displaying the data for another filter (Shift - sorted by Machine) in descending order.
As you configure the filter conditions and the sort order, GainSeeker displays the equivalent SQL (Structured Query Language) WHERE clause that represents your selections.
If your filter and/or sort settings are not complete, a red X is displayed and the status bar indicates one of the boxes that needs to be changed. Also, the boxes that need to be changed are colored pink like the example below (although on some operating systems and/or display configurations, this color may not be very noticeable).
When your filter has enough definition that it can be saved and used, the red X will change to a green check mark. Now you can click OK to save your filter.