Where Clause Details
Where clause works like a filter for extraction and enables you to extract only data that you require.
From this tab you can:
The fields in this window are described in the table below.
| Open ( | Allows you to put your where clause into parentheses. Use the up arrow to open the parenthesis. |
| Table Name | Refers to the table or relationship name from which the data will be extracted. |
| Column Name | This is the field or column on which you are filtering. |
| Case Insensitive | Select this check box to fetch case-insensitive data. |
| Operator | Select the mathematical or logical operator such as Equal, Less Than, Greater Than, and so on depending on the records you want to extract. |
| Low Value |
Low and High values together enable you to provide a range of values. Low value is the starting value. Note: If providing only one value, provide a value in the low
value field. The High Value field should be left blank.
|
| High Value | A high value is relevant only when a low value is provided. The high value would indicate the end of the range. |
| Close ) | Close the parenthesis. |
| Compound Operator | These are operators between two fields. |
| Filter type | This enables you to specify a date field on which you can filter your extraction. By specifying a date range on the Infor Risk & Compliance user interface you could fetch all records that were created or updated within that date range. |