3.9.5 Select the Same Criterion to Apply One or More Conditions

This topic describes the systematic instructions to select the same criterion to apply one or more conditions.

Now, you may want to make a query to see the loans (in the Loans and Deposits module) involving three different products and having a rate less than 12 percent. This involves specifying the products one by one all of which come under the same criterion - Product (listed out under Fields) and indicating a rate range for them.

1. Click on Product in the Fields list, specify the Operator as Equal To and pick out the product from the Value option list, say LDSP and click Accept button.
2. To select another product, click OR button and then click Product in the Fields list, specify the Operator as Equal To and pick out the product from the Value option list, say LL05. Repeat the process for the third product, LL07.
3. To call out loans involving these three products with an interest rate less than 12%, click AND button and specify the rate condition. Pick Rate from the Fields list, specify the Operator as Less than and give the Value as 12. Click Accept button.
   You will see the following query in the Query screen:

   PRODUCT = `LDSP OR PRODUCT = `LL05 OR PRODUCT = `LL07 AND RATE < 12

4. Now click Ok button to see the query.
   You will see displayed in the LD Contract Summary screen, all the loans with an interest rate less than 12% for the three products you have specified.

(Optional) Enter the result of the procedure here.