9.1.4 Ordering Details of Query

Oracle Lending also provides you the option to order the information that you have made a query on. You can further specify that the ordered information should be arranged in ascending or descending order.

Figure 9-2 Ordering Details of Query

Description of "Figure 9-2 Ordering Details of Query"

Suppose you have made a query to obtain details of the debit messages that were generated by the Data Entry module of Oracle Lending, and you want to order the information in the ascending order of the customer to whom the message was sent.

Make the query following the procedure detailed under the head making a Query after you have specified the entire criterion for the query, select the required ordering option from the Order By drop-down list. The list contains the following options:

• Ascending
• Descending

Click the option of your choice, say, Descending.

Click the Accept button and click Ok. The details of the query that you have made are displayed on the Outgoing Browser ordered on the basis of the customer to whom the message was sent. The details are further sorted in the alphabetic order.

If you decide to cancel the ordering you have specified, click Clear Query. The screen clears and you can specify a new order.