1. Messaging System User Guide
  2. Making Query
  3. Advanced Search
  4. Select Same Criterion to Apply One or More Conditions

11.1.3 Select Same Criterion to Apply One or More Conditions

This topic provides the systematic instructions to select 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.

  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 cull 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 will display details of all the debit advices generated for the LC module from your branch at London to the three customers that you specified.

Parent topic: Advanced Search