How to restric the search query max read of 100 rows ?
Author: firstname.lastname@example.org (Jayesh82mscit)
Hi All, In order to provide optimized experience to the customer on the search page, there is a need of restricting the RETRIVAL result from Database (through Uniface code) based on the user input SEARCH criteria. Can the retrieval criteria be controlled to fetch only lets say 100 rows only ? Please note that we don't want to manipulate the result set by any customized code of looping through and discard beyond 100 records etc. Would like to explore if any Uniface function available to achieve this requirement ? Thanks, Jayesh