Use this dialog to create and edit custom folders. You do this by entering a SQL select statement. Like other folders, cu stom folders require joins in order for their data to relate to other data in the business area.
For more information, see:
Use this field to enter the SQL statement that will define the folder. For example:
SELECT ENAME, JOB, SAL FROM EMP@ORCL
The Discoverer Administrator then creates items for each of the select list items. In Discoverer Plus, end users can use custom folders to build queries in the same way as for other folders.
You can enter up to 2,000,000,000 characters in this field.
Use this field to enter a name for the folder.
Use this button to validate the SQL statement at any time before saving it. An invalid SQL statement prompts an error message.
Use this button to validate the SQL statement and save the custom folder.
Discoverer allows you to save the custom folder even if the SQL is invalid. This allows for situations where the SQL must be inserted into the EUL before the actual database objects are created or made available. However, users will not be able to query it until the SQL is corrected.
If the SQL is invalid and you want to correct it, select the custom folder in the Data tab and right-click to access its Properties dialog. Double-click the Custom SQL field to display the Custom Folder dialog.
This dialog becomes read-only if the current user does not have the Create/Edit Business Area privilege (for more information, see "Privileges dialog: Privileges tab"). When this dialog is read-only you can still copy and paste the SQL statement to another document.
When a custom folder is based upon a view and you update the view (for example, by adding a new column), the update will only become available in Discoverer if you refresh the business area. For more information, see "How to synchronize a business area with the database".
Discoverer does not allow you to use the WITH clause in the custom folder SQL.