Discoverer Plus - Conditions - Creating Conditions

...

Distribution

ODS Specialist

ODS Specialist-Limited

ODS Specialist-Restricted

Ownership

The ISDS System Usability Director is responsible for ensuring that this document is necessary, reflects actual practice, and supports University policy.

Discoverer Plus
M ® File ® Edit Worksheet
Edit Worksheet

Creating Conditions

After you have selected the items to be included in your query, the next step is to create at least one or more conditions that will limit the data to your specific needs. If you do not create at least one condition, you will either receive much more data than you wanted, or you will have created a report that runs forever and ever.

Before you select an item, click on the + sign to the left of the item to view choices. Some items contain defined Lists of Values (LOV)- such as the example below where the individual Trainer names are choices.

1. Select the item you want to add..

Selecting the specific name is an easy way to create a condition if a List of Values has been defined.
If you select a specific item you might not get any data, because it is SO specific.

2. Either Drag the item to the Selected panel or click the Right arrow in the central panel to add the item.

The screen shot shown below shows

Selected Items and their folders

[New] button allows you to create Conditions, Calculations, Percentages and Totals.

Conditions –limit your data retrieval.
Be sure to create a condition (or conditions) that will limit the data to your specific requirements. In the example above the conditions set are the trainers’ names from an ITEM.
In the example below you are creating a NEW condition.

3. Select, [New].

You can base the condition on an item or a condition.
The default is to have the system generate a name automatically, but you can uncheck that option and give it a name of your choice.
You can enter a description, but it is not required.

If you do not give the item a description here, make sure to note this step elsewhere, like in the title or the text area, so that you will not forget the reasoning behind the condition.

4. Select the down arrow under [Item].

5. Select the item on which you want to base the condition.

The screenshot below the Trainer Name is the item selected.

6. Select the Condition.

“LIKE” allows the use of the wildcard, %.

Conditions

*Expression*	*Meaning*	*Example*
=	Equals	Region = ‘Central”; only the Central Region data is displayed.
<>	Not equal	Region <> ‘Central’; all other region data except Central is displayed.
>	Greater than	Profit SUM > 10000; all Profit Sum items greater than 10000 are displayed.
<	Less than	Profit SUM < 10000; all Profit Sum items less than 10000 are displayed.
<=	Less than or equal to	Profit SUM <= 10000; all Profit Sum items less than or equal to 10000 are displayed.
>=	Greater than or equal to	Profit SUM >= 10000; all Profit Sum items greater than or equal to 10000 are displayed.
LIKE	Similar to (using Wildcard matching	Name LIKE ‘A%’; finds all names beginning with the letter A. The percent (%) sign matches any number of characters. A dash symbol (-) matches a single character. NOTE: You can use wildcard in multiple places, ie; org name like ‘%INMD-%’
IN	Contains one or more values	City IN (‘Boston’, ‘Los Angeles’, ‘New York’); finds data that contains at least one of the values.
IS NULL	Contains no data (not even zero)	Commission IS NULL; displays data only when commission has no value.
IS NOT NULL	Contains some data (even zero)	Commission IS NOT NULL; displays data when commission has any value.
NOT IN	Is not contained in one or more values	City NOT IN (‘Boston’, ‘Chicago’); does not display data that contains the words Boston or Chicago.
BETWEEN	A value that lies between two other values	Profit BETWEEN 1000 and 2000; displays profits greater than or equal to 1000 or less than or equal to 2000.
NOT BETWEEN	A value that lies outside of two other values	Profits NOT BETWEEN 1000 and 2000; displays profits less than 1000 or greater than 2000
NOT LIKE	Not similar to	Name NOT LIKE ‘A%’; finds all names not beginning with A. The percent (%) sign matches any number of characters. A dash symbol (-) matches a single character.
!= and ^=	Not equals	Region != ‘Central’; finds all regions except Central. *Note: these two expressions have the same meaning because both are supported by SQL programming. Therefore, if you use a SQL programming statement to create a complex conditional value, Discoverer can recognize it regardless of which expression you use in the program.

Effective: 7/20/2010

Revision: 1

Oracle Tutor can be licensed to modify and add to this content, documenting all of your business process documentation in the Oracle Tutor format.

Expression

Meaning

Example