3.9.7 Use Wildcards to Make a Query

This topic describes how to use wildcards to make a query.

You need not always specify the criteria. You can use Wildcards such as * or %, to see a particular set of criteria. For instance, in the Loans and Deposits module, you have defined both loan products. All loan products have a Product Code that starts with LD (LD01, LD02 etc.), and all deposit products have a Product Code that begins with DP (DP01, DP (DP01, DP02, etc.).

Now suppose you want to see only the loan products and you know that they all begin with LD, instead of specifying each from the list of Values, you can give the Operator as Like and in the Value field key in LD%.

Once you click Accept and make a query, the Contract Summary screen displays all the loan products.