• Skip to primary navigation
  • Skip to main content

Tech Honey

The #1 Website for Oracle PL/SQL, OA Framework and HTML

  • Home
  • HTML
    • Tags in HTML
    • HTML Attributes
  • OA Framework
    • Item in OAF
    • Regions in OAF
    • General OAF Topics
  • Oracle
    • statement
    • function
    • clause
    • plsql
    • sql
You are here: Home / OAF Miscellaneous / OA Framework LOV Criteria

OA Framework LOV Criteria

October 27, 2012 by techhoneyadmin

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

Bye

Filed Under: OAF Miscellaneous Tagged With: criteria of LOV in oa framework, lov criteria oaf, oa framework lov criteria, oaf lov criteria, what is lov criteria in oa framework

Copyright © 2023 · Parallax Pro on Genesis Framework · WordPress · Log in