Use attribute-to-attribute qualification filters to compare attributes based on the value of their Attribute forms . For example, use attributes to view data for only new customers whose First Order Date is equal to their Last Order Date.
To create a stand-alone attribute-to-attribute qualification filter:
On the
project main page, click Create Filter
to view the New Filter screen.
Or, from the Admin menu, choose Filter. From the Filters page, click
the Create Filter icon.
In the pane on the left, navigate to the first attribute whose form you want to use to filter report data.
Right-click the attribute and select Add to Filter.
Click Qualify.
From the first drop-down list, select the form to use to filter the data.
Click
the Attributes icon to view the Select
an Object dialog.
Navigate to and select the second attribute to use in the comparison.
Click OK to return to the New Filter screen.
From the second drop-down list, select the operator that describes how the data should be filtered, such as Equals or Less Than.
In the last drop-down list, do one of the following:
Select an attribute form for the second attribute. This is the value that will be compared against the form of the first attribute.
Select New Attribute to select a different attribute for the comparison.
Click Apply to create the filtering condition.
Click Save As to open the Save As dialog and navigate to the folder to save the filter.
Type a Name and Description for the filter, and click OK to save the new filter.
The new filter can now be added to a report.
Adding a stand-alone filter to a report.
_____________________________
Copyright © 2019, Oracle and/or its affiliates. All rights reserved.
Legal Notices