Filter Tab

The Filter tab is another way to select data.

The default setting is All data. In other words, no filters are applied to your selection of data with the default setting.

The default setting, All Data is the same as saying there is no filter with this setting.

However, you can create additional filters that reflect your interests.

Filter-tab options

To create new filters

  1.  Click on New. You will see a Traceability Filter dialog.

  2. It is a good idea to give the filter a name reflecting its purpose (see picture below). The filter name can be up to 40 characters.

The program automatically names new filters -- New Filter.  To give the filter a different name, enter a name in the Filter name box.  Use names that describe what the filter does.  Such names will be especially useful if you include the filter name on the report.

Note: Do not use “Quick Filter” as the name of your filter. Creating a filter with this name may produce unintended results.

 

 

  1. To choose a Field name, click on Field Name.

  2. Click on the down arrow in the text box right below it. You will see a drop-down list of possible field names. Highlight your choice.

  3. Follow steps 3 and 4 again to choose names for Test, Value and Operation. See an explanation of these categories below in "How to use the filter categories".

How to use the filter categories

Creating a filter is like writing a sentence. It begins with a subject (Field Name), followed by a verb (Test) and ending with an object (Value).

Select NONE for a simple filter (one line). For a complex filter (two or more lines), choose AND or OR. In a two-line filter, use OR when you want to display values for data that pass either of the conditions. Use AND when you want to display values for data that pass both of the conditions. You can use OR or AND for as many conditions as you want.

By pressing the SQL statement button, the filter status window will display the filter commands as a query statement. For the above filter the statement would be

((UDL1 = 'AB 5001' OR UDL1 = 'CD 1001') AND UDL2 = '1')

Right Click Functions are available within the filter fields.  If select a row then right click the following menu appears:

Show list will display a drop down list of available options for the selected field

Delete Row allows you to delete the contents of an entire row.

Cut Row allows you to delete the contents of an entire row and move it to the clipboard for pasting in another location.

Paste row will paste a cut or copied row to where you place your cursor. Note: If you paste the row into a row that already has text (i.e., another filter), it will overwrite that filter.

Note: If you paste the row into a row that already has text (i.e., another filter), it will overwrite that filter.

 

 

Insert row will duplicate the cut or copied row in the row above where you place your cursor. It will not overwrite the row.

Copy row copies the row where you have your cursor. Then use Paste row or Insert row to duplicate the row in another location.

Ending your Filter session

To finish your filter session:

-- or--