Page Comparison

...

1. Right-click on a field from the left Search fields navigation pane. 
   
   
   
   
2. Click Filter from the menu that displays. 
   
   
   
3. Notice a Create a filtering condition dialog box displays with the basic framework for a WHERE statement.  The arithmetic operator is set to Equal to, by default.   
4. Modify this operator by double clicking Equal to. 
   
   
   
5. Then click the "Equal to" dropdown arrow to display the available options.  
6. Click to select an option from the list, as desired.  
   
   
   
7. To modify the type of filter in use, double-click the <Value> field.
   
   
8. Then click the "Value" dropdown arrow to display a list of additional options.
   
   
   

9. From the Value dialog box, click the Type dropdown arrow to modify this selection as desired.  Available options are listed and briefly defined below.  

   1. Constant. Allows the entry of a literal value. This value can be a positive number, a negative number, or any character string.
   2. Parameter.  Allows you to specify a parameter by entering a name and description in the provided text input areas, as well as selecting the type of parameter (Simple, Static, or Dynamic). 

   3. Field. Allows the specification of a field name to compare against.
      
      

      NoteFor the purpose of this documentation we will use Constant as the Type selection.  

      
      

Constant Filter Type 

1. The Constant selection from the Type dropdown, allows you to either:
   1. Type the value(s) in the Value field. 
   2. Highlight the line item in the left  Value pane.
   3. Then click the double chevron to add it to the list of available options. 
      
   4. Repeat these steps for each value that should be added.  
      
      OR, 
      
      
   5. Retrieve all the available values from the database, by clicking the Get Values dropdown.
   6. Select an option from the dropdown.
   7. Then click the respective double chevron.  
      
   8. Repeat these steps for each option that should be added from the Get Values dropdown.  
      
      
2. Once the values appear on the right, within the Multiple Values: pane, select a value and click the up/down arrows to reorder, or click the red X to delete a value from the right.  
   
   
   
3. Click OK to confirm and return to the WHERE statement view.  

Dynamic Filter Type 

1. MM left off here - 5/19/21
2. test
3. test

Parameter Filter Type 

1. test
2. test
3. test

Related Articles

...