The ISDS System Usability Director is responsible for ensuring that this document is necessary, reflects actual practice, and supports University policy.
To create multiple conditions for the same condition name, click Advanced in the New Conditions dialog box. The Edit Condition dialog box is displayed. Then follow these steps:
Condition groups are displayed in the Formula region in the Edit Condition dialog box. If you want to edit the conditions, you can do so from this dialog box.
The results window displays the results of the grouping conditions.
For instance, you want to find the expenditures for all Educational and Food and Drink expenditure category types.
In the example above, the condition is:
AND has precedence over OR, while nesting conditions alter the default precedence. Review the conditions above. In this example, AND has precedence over OR because it is a nested condition.
Note: To group, hold down the shift key and select items to group, chen click [And] or [Or] as appropriate.
By default, the AND operator is used to combine conditions. To toggle between AND and OR, double-click the Group field. To create a condition with multiple logical operators, follow these steps:
A nested condition is a condition that contains other conditions as its components.
1. Select [Edit, Worksheet, Conditions tab].
2. Select [New].
3. Select [Condition] from the Items column dropdown.
4. Select [Advanced].
5. Select a logical operator to group the conditions.
6. Click at the drop down of the Item field. The following list appears:
7. Select the particular condition you want to nest and select [OK].
A parameter is a value within a condition that you specify when you run a query. You use parameters to change conditions without having to change the query.
If a query includes a parameter, you are prompted to specify the information you want to see when you run the query.
For example, you can create a parameterized query that prompts you for an Event Activity Name.
1. Add to the worksheet the condition on which you want to base the parameter.
2. Select [Tools, Parameters] to edit existing parameters as in the case shown below, or to create a new parameter.
3. Select [Edit].
In the example below we selected:
4. Select the Refresh icon.
The Edit Parameter values window appears.
5. Select the value(s) for the parameters you seek.
6. Select [OK] to run the query.
1. Select [Tools, Parameters, New] to open the Parameters dialog box.
You can go to this window DIRECTLY from the condition. In the values area select [New Parameter].
2. When you modify a parameterized condition the name of the parameter appears in the name field.
4. Description: Enter a description of the parameter that is displayed in the Description area of the Available Parameters dialog box.
5. Default Value: Select a value from the drop-down list to be used as a default if no value is selected in the Parameter Wizard.
Note: To change the conditional operator for a parameter, you must modify it in the Edit Condition dialog box. To disable a parameter, you must disable the condition.
Oracle® Tutor Copyright © 1997, 2010, Oracle & UVa. All rights reserved.