9.1.3 Selecting Same Criterion to Apply One or More Conditions

Now, you may want to make a query to see the debit advices (in the Letters of Credit module) that were generated from the London branch involving three different customers (Wendy Klien, Silas Reed and Keturah Smith).

This involves specifying a customer code one by one all of which come under the same criterion module -- LC (listed out under Fields) and indicating a message type for which you want details. This is where the Or button on the query screen comes into play. You can choose to use the keyboard to key in the query or you can follow the following procedure to make a query.

The procedure to make such a query involves the following steps:

1. Select Module under Fields, and then from the operator drop-down list choose Equal To and LC under value. Then, click the Accept button.
2. Click the And button. Repeat step one with criteria Field as Branch, Operator being Equal To and London under value. Click the Accept and Add buttons in the sequence described in Step 1.
3. Click the And button. Repeat step one for field with the criteria value, as Message Type. Then select debit message under value clicking the Accept and Add buttons in the sequence described for the first criterion.
4. To call out details of the debit advices involving these three customers, click the And button. Repeat Step 1 with the Field as Name. Select say Ms. Keturah Smith under value. Then click the Accept button.

   To select another customer, click the Or button and then click Name in the Fields list, specify the Operator as Equal To and pick out the customer name Mr. Silas Reed from the Value option list then click the Accept button.

   Repeat the process for the third customer, Ms. Wendy Klien

5. The query that you have made is displayed on the Query screen.

   MODULE = LC AND BRANCH = LONDON AND MSG_TYPE = DR_ADV AND NAME = SILAS REED OR NAME = KETURAH SMITH OR NAME = WENDY KLIEN

   Check it for correctness and click Ok button to see the query through. The Outgoing Message Browser displays the details of all the debit advices generated for the LC module from your branch at London to the three customers that you specified.