Discussions
Categories
- 195.9K All Categories
- 2.1K Data
- 208 Big Data Appliance
- 1.9K Data Science
- 447.1K Databases
- 220.7K General Database Discussions
- 3.7K Java and JavaScript in the Database
- 23 Multilingual Engine
- 516 MySQL Community Space
- 463 NoSQL Database
- 7.7K Oracle Database Express Edition (XE)
- 2.9K ORDS, SODA & JSON in the Database
- 461 SQLcl
- 3.9K SQL Developer Data Modeler
- 185.8K SQL & PL/SQL
- 20.9K SQL Developer
- 292.4K Development
- 7 Developer Projects
- 120 Programming Languages
- 289.1K Development Tools
- 94 DevOps
- 3K QA/Testing
- 645.4K Java
- 21 Java Learning Subscription
- 36.9K Database Connectivity
- 150 Java Community Process
- 104 Java 25
- 22.1K Java APIs
- 137.8K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 14 Java Essentials
- 142 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
- 197 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 219 LiveLabs
- 34 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
- 225 Portuguese
Too many matching records found. Specify additional criteria to limit the number of records
I have a LOV in the UI. Upon clicking it, it shows the values in it. Upon selecting a particular value in that LOV, the following error pops up saying that:
"Too many matching records found. Specify additional criteria to limit the number of records."
This happens only for the first value that I am selecting from the LOV. If I select a different value from the LOV again, this error doesn't appear.
Please help! Thanks in advance.
Answers
-
Timo Hahn Senior Principal Technical Consultant - Oracle ACE Director Member, Moderator Posts: 37,480 Red DiamondUser, tell us your exact JDev version, please!
You normally get this message if the VO or collection behind the LOV has duplicate entries. If you now select one of the duplicate values you get this error as the e.g. selectOneChoice can only select one.
If you use a VO behind the LOV check if you have selected a primary key in the VO and rewrite your query that it returns unique values.
Timo
-
JDev version is 11.1.1.9.0
Also, the VO behind the LOV has a primary key defined.
-
Timo Hahn Senior Principal Technical Consultant - Oracle ACE Director Member, Moderator Posts: 37,480 Red Diamond
And the query for the LOV returns unique values?
If yes, do you have a reproducible test case?
Timo
-
Yes, the issue can be reproduced on one of our Fusion env. I think it will be easier to show you via a zoom if possible.
-
Timo Hahn Senior Principal Technical Consultant - Oracle ACE Director Member, Moderator Posts: 37,480 Red Diamond
Sorry, this is a public forum and we should keep it this way. Zoom is not an option here as it would not address everybody.
I'm not the only member that might be able to help you solve the problem.
Timo