As the name suggests that an LOV Criteria is just adding a where clause to the existing LOV query, lets understand this with an example.
Suppose you have an LOV on Employee Name, then whatever user enters in the LOV input field before clicking the LOV icon becomes the criteria for the LOV to fetch the data e.g. if the user enters “Jo%” (without quotes) and then clicks on the LOV icon then the results displayed in the LOV region will be all the names that start with “Jo” like “John” “Jonathan”, “Joy”, “Jonny” and so on.
Similarly if the user enters “Su%” in the LOV input field and then clicks on the LOV icon then the LOV region will display names which starts with “Su” e.g. “Susan”, “Suzie”, ”Suzuki” and so on.
This means that the value entered in the LOV input field becomes a criterion for the LOV region to fetch and display results and the results are being fetched and displayed with respect to the partial data entered in the LOV input region.
Thanks for Reading