Oracle9iAS Discoverer Plus User's Guide Version 9.0.2 Part Number A90879-02 |
|
Use this dialog to change the way that the currently selected condition item behaves. For example, you might want to change its name, description, or the way that it filters data in the worksheet.
For more information, see:
Use this field to enter a descriptive name for the condition item. This name is displayed in the condition list on the Conditions dialog.
Use this check box if you want Discoverer to create a default name for you. The default name is based on the condition syntax.
Use this field to enter a brief description for the new condition. This description is displayed in the description box on the Conditions dialog and helps workbook users choose which condition they want to use.
This area is where you build the condition. The condition can contain one or more condition statements.
Use this drop down list to filter the worksheet by selecting an item to match against. For example, to filter information about people who earn more than $30,000, you might choose an item called 'Salary' here.
This drop down list displays a list of operators that you can use to match against the Item. For example, if you want to filter information about people who earn more than $30,000, you might choose the greater than operator (>) here.
Use this field to enter a value that you want to use to match against the selected Item. For example, if you want filter information about people who earn more than $30,000, enter 30,000 here.
Use this check box to make the condition case sensitive when matching against text data. For example, if turned on, the value 'New York' would not find details containing 'NEW YORK' because the text cases do not match exactly. If turned off, the value 'New York' would find details containing 'NEW YORK' and 'new york'.
Use this button to expand the dialog box enabling you to apply multiple condition statements to an item. The expanded dialog displays New Item, And, Or, Delete and Undo buttons. A Group column is also added to the Formula box (see Group below).
Use this button to add a new condition statement line to the condition. By default, new condition statement lines are grouped with the logical AND operator. In other words, the data must satisfy both condition statements to be filtered in the worksheet (see Group below).
Use this button to add a new condition statement line to the condition and group it with the previous condition statement line with a logical AND operator. For example, with two condition statements, data must match condition statement one and condition statement two.
Use this button to add a new condition statement line to the condition and group it with the previous condition statement line with a logical OR operator. For example, with two condition statements, data must match either condition statement one or condition statement two. (In SQL terms, this is an inclusive OR clause.)
Use this button to remove the currently selected condition statement line from the condition.
Use this button to retrieve the deleted condition details if you delete a condition statement line from the condition and then change your mind.
Use this button to change the Group operator to a logical `AND'. You must have the current Group item selected.
Use this button to change the Group operator to a logical `OR'. You must have the current Group item selected.
Use this button to change the Group operator to a logical `NOT AND' operator.
Use this button to change the Group operator to a logical `NOT OR' operator.
|
Copyright © 2002 Oracle Corporation. All Rights Reserved. |
|