1.2 Summary Query performance Enhancements
This topic provides an overview of summary query performance enhancements for handling the high volume data.
- Criteria Based Search
- Minimum number of Search Characters
- Lov Details
Figure 1-4 Summary Details Screen
Criteria Based Search
Minimum Number of Search Characters
If the user wants to provide minimum search character length for the Lov for handing high volume data, the user has this option to provide a minimum number of characters required for the Lov to fetch the result of Lov.
If the user is not providing a minimum number of characters of the Lov while querying in the Summary screen, then the user will get an error message to provide minimum search character length.
There is a restriction to this field. If the user enters a value that is greater than the value of the field in the data source level, then ODT will not allow it, it will throw an error message.
LoV Details
If a particular summary field needs to be attached to a Lov, then the user has to provide these details on click of the Property button. The user can map the corresponding return fields and the related bind variables.
Click Default From Lov Definition, then choose the required query columns, corresponding Block Name and the Return Field Name.
Parent topic: Definition/Modification of LOVs