Figure 1: Filter Options Tab
Note: Below, you can find the description of this filter form. However, if you are interested in getting detailed help about using this filter form for applying filters, then click on: http://www.monitorware.com/Common/en/Articles/guide-for-applying-filters-mwconsole-21.php
Add Filter
When you click on this column, it displays you a list of all those columns on which you can apply filters.
AND
When you press on this button, it adds an "AND" node on the left side in the tree view. The columns that come under this node are ANDed together
OR
When you press on this button, it adds an "OR" node on the left side in the tree view. The columns that come under this node are ORed together
NOT
When you press on this button, it adds a "NOT" node on the left side in the tree view. The condition that come under this node are NOTed (i.e. if true, it becomes false and vice versa)
Change Operator
If you click on this button after selecting some AND, OR or NOT node, it changes the operator if possible.
Up Arrow
It simply moves the selected node one place above in the tree
Down Arrow
It moves the selected node one place down in the tree
Delete
It simply deletes the selected node and all its children
Select Operator
Several operators are provided for applying meaningful filters. These operators generally correspond to the most common SQL operators that may be mentioned in the WHERE clause. For additional information on the use of operators see Operators' Reference.
Select Lower Value
In the "Select Lower Value" combo box, values corresponding to the selected field (Select Column combo box) are picked from the database for user's convenience.
Note: Only top 100 values corresponding to each field are picked for this purpose. However, users can enter their own values if required.
Select Upper Value
In the "Select Upper Value" combo box, values corresponding to the selected field (Select Column combo box) are picked from the database for user's convenience.
Note: Only top 100 values corresponding to each field are picked for this purpose. However, users can enter their own values if required.
Add
This button is enabled only when "is one of" or "is not one of" operator is selected from "Select Operator" Combo box. You can select different values from "Select Lower Value" combo box and click this button to add to the list on its right. Please note that the filter does not add, until you click on "Add Filter" button.
Remove
This button is enabled only when "is one of" or "is not one of" operator is selected from "Select Operator" Combo box. You can select different values from the list on its right and click this button to remove them from the list on its right. Please note that the filter does not update, until you click on "Add Filter" button.
Set Value
If you click the "Set Value" button, after specifying the filter, adds that filter to be applied to the report. All added filters are displayed in the text box on the filter form. Any number of filters may be added.
Note: Some of the controls on the filter form are only enabled under special conditions. For example, the date time picker controls are only enabled when the selected field is of DateTime type. Controls in the section "Select Upper Value" are only enabled if the selected operator requires a range of values rather than a single value. For example, "is between" operator requires a lower and an upper value to be defined for its proper working.