Define a Filter in Oracle That Displays All Documents Created Today

Contents

To define a filter in Oracle that displays all documents created today:

1. From a log window, click the Layout drop-down list and select Customize Layouts.
2. Open the Customize Layouts Dialog Box and click filter.
3. From the Filter Dialog Box, click Add to open the New Filter Dialog Box.
4. In the Title field, enter a title for the new filter.
5. Click Advanced Filter, and choose Yes in response to the prompt. The Filter Dialog Box (Advanced) will open.

   Caution: You should only click Advanced Filter if you know and understand SQL syntax, which you will use to build and edit the filter manually. If you click Advanced Filter, and click Yes to confirm that you want to use an advanced filter, you will be unable to change back to the standard filter.

6. Enter the following in the Criteria field:

   created_date >= trunc(sysdate)

7. Click Save and Return to Filter List.
8. Click Return to Menu.

The filter can now be used.