- 382.3K All Categories
- 2.1K Data
- 209 Big Data Appliance
- 1.9K Data Science
- 448K Databases
- 220.9K General Database Discussions
- 25 Multilingual Engine
- 520 MySQL Community Space
- 467 NoSQL Database
- 7.8K Oracle Database Express Edition (XE)
- 2.9K ORDS, SODA & JSON in the Database
- 492 SQLcl
- 3.9K SQL Developer Data Modeler
- 186.2K SQL & PL/SQL
- 21K SQL Developer
- 293.3K Development
- 7 Developer Projects
- 128 Programming Languages
- 290K Development Tools
- 95 DevOps
- 3K QA/Testing
- 645.5K Java
- 24 Java Learning Subscription
- 36.9K Database Connectivity
- 149 Java Community Process
- 104 Java 25
- 22.1K Java APIs
- 137.9K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 16 Java Essentials
- 144 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 198 Java User Groups
- 266 LiveLabs
- 36 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.8K Other Languages
- 2.3K Chinese
- 166 Deutsche Oracle Community
- 1.2K Español
- 1.9K Japanese
- 230 Portuguese
Limitation in using model driven LOV
When we use model driven LOV, we create List of values to a view attribute. This list of values is a SQL query based View object in itself. The below example will show the limitation we are facing.
1. An EO based view object EmployeesVO is created.(Attributes Title, FirstName, LastName)
2. The attribute Title is defined a List of Values to it and set the list type as choice list.
3. This list of values is a query on some table, eg: lookup_values where lookup_type = 'TITLE' and enabled_flag = 'Y'
4. When creating a Table UI with this set-up, the title field shows the list of values of all values from lookup_values where lookup_type = 'TITLE' and enabled_flag = 'Y'.
5. lets assume an employee record is created with title as "Dr", which is a value from the choice list.
6. I am updating the value of "Dr" in lookup_values, column enabled_flag = 'N'. (this will filter the record from the list of values, as it expects that enabled_flag should be 'Y')
The expectation is that this value should not be displayed in the list of values for all records that I want to create in future.
But what happens when I query the already created employee records with Title as "Dr", is that those records do not show the Title value "Dr". I guess since the value is filtered by the List of values query, it will not be shown on the already created employees as well.
Since this is a common requirement (ie, user would not want some value to be not available to pick from a list, however would still want to see that value for records which were already created), my questions are,
1. is this how the framework is supposed to behave, or am I doing something wrong in using this functionality?
2. is there any work-around for this? (to filter a value from LOV, yet still show that value for records that were already created.)
let me know if any more information is required to clarify.