This topic provides detailed information on exact fetch.

If the Block field is of Display Type LOV , the developer can choose the exact fetch parameter for search optimization (in High Volume). If the Exact Fetch parameter is selected, the user has to provide the exact values of the field as it is present in the Database, otherwise, the system will throw the error message as an invalid value. Wildcard Searches are not permitted.

For example: Entering 98712 in the Account Number field will fetch value only if an account with that particular number exists. In the Normal case, all account numbers beginning with the search pattern would be retrieved.

Figure 2-1 Block Field Properties – LOV

Description of "Figure 2-1 Block Field Properties – LOV"

Figure 2-2 Select Fields – Webpage Dialog

Description of "Figure 2-2 Select Fields – Webpage Dialog"

Figure 2-3 Information Message

Description of "Figure 2-3 Information Message"