11.1.2 Make Query based on more than one Criterion

This topic provides the systematic instructions to make query based on more than one criterion.

Suppose you want to obtain information based on more than one criterion. For example, you may want to view the details of all the guarantees generated for the Letters of Credit module from your branch located at London.
The procedure to make such a query involves the following steps:
Action Button
Accept The Accept button
And The And button
  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 the criteria value, as Message type, select Guarantee under value clicking accept and add buttons in the sequence described for the first criterion.
  3. Click the ‘And’ button. Repeat step one with the criteria value, as Branch select London under Value clicking accept and add buttons in the sequence described for the first criterion.
  4. The query that you have made will be displayed in the Query screen. Check it for correctness and click ‘Ok’ button.
The Outgoing Message Browser will display details of all the Guarantees generated for the LC module from your branch at London.