Aug 1, 2011

Resetting the Query


Resetting the Query Criteria for a Folder Definition
1. (M) Folder > Reset Query, to clear the WHERE clause from the current folder definition, but it will retain the current folder name and its field layout. To view the query criteria for a folder definition, (M) Folder > View Query.
2. Perform another query and (M) Folder > Save to save the new query to your current folder definition.
3. To alter the sorting order of data in a multiple-record folder definition, (M) Folder—>Sort Data.
4. Choose one of the following sort options:
Ascending
Descending
Unsorted
Note: Only the first three columns of a folder can be sorted.
5. Select View > Query By Example > Run to rerun the query in your folder definition to apply any ordering changes to the records.
6. Select Folder  > Save or Folder > Save As to save this query criteria to a folder definition.
Accessing Folder Tools
When you navigate to a folder block, the Folder Tools button becomes enabled on the Toolbar. Click this button to display the folder tools on your screen.
Using Direct Manipulation Techniques on Folders
You can directly manipulate folder columns using the following techniques:
Drag the right edge of a prompt to resize the column.
Drag the center of the prompt to resequence the columns.
Delete the prompt to hide the column.
Left-click on the first three prompts to sort them.
Right-click on any prompt to change the label.
For more on using folders, see Oracle Applications User’s Guide online help.

Recovering the Original Default Folder Definition for a Folder
Once you create a custom folder definition and make it the default, you can recover the original default folder definition shipped with the product. Note that if you like the original default folder definition, give it a name and save it (without making any changes) before you create any new folder definitions. This way, you can open the original folder definition by choosing it from a list of all your predefined folder definitions.
1. With the folder currently specified as the default displayed, (M) Folder > Save As.
2. Clear the Open as Default option in the Save As window.
3. Click OK when you are finished.
4. Navigate to this form again to display the original default folder definition.
Opening Another Folder Definition
1. (M) Folder > Open to load a predefined folder definition. Or, click the Open Folder button located in the upper left corner of the folder block.
2. Select a private or public folder definition from the list window that is displayed, and click OK to replace the current folder definition with the new folder definition.

Saving Changes to a Folder Definition
1. (M) Folder > Save to save any layout or query changes made to the current folder definition or (M) Folder > Save As to save the current folder definition under a new name.
2. Click OK after you have completed the information requested in the Save Folder window.
If you save a folder definition to Open as Default and then open another folder definition and save that second definition also as Open as Default, the second definition is reset as the new default.
If you modify a public folder definition in any way, saving it makes a copy of it that is a private folder definition.
Deleting a Folder Definition
1. Select Folder > Delete.
2. Select a folder definition from the list that is displayed and click OK to delete the definition. Note that you can only delete folders you have created. If another user is referencing that folder definition as their Open as Default folder, that reference is deleted as well.

Folder Practice Solution
(M) File > Switch Responsibilities, select Receivables, Vision Operations from the list and click OK.
(N) Customers > Summary. Click the Find icon on the toolbar.
In the Find Customers window, click on the LOV in the Customer Name field and enter search criteria, such as AT%, then click the Find button.
When the list appears, select AT&T Universal Card from the list and click OK.
In the Find Customers window, click on the poplist in the Status field and select Active.
Click the Find button.
To create a folder, (M) Folder > New. Enter your name as the name of the folder definition. Accept the defaults for other fields.
Place your cursor in the Alternate Name field and (M) Folder > Hide Field.
Place your cursor in the Taxpayer ID field and
(M) Folder > Hide Field.
Hold the mouse over the Use field’s prompt and click and drag it to the far left.
(M) Folder > Save
(N) Customer > Summary
Click the folder icon in the top left corner of the window to open a list of folder definitions.
Highlight your folder definition and click OK.







No comments:

Post a Comment