Discussions
Categories
- 196.9K All Categories
- 2.2K Data
- 239 Big Data Appliance
- 1.9K Data Science
- 450.3K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 545 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.9K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.6K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 155 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 440 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
Why are there all criteria views in my query?

Hello
im currently working with JDev version 12.2.1.4.0
I created 2 Entitybased view Objects that are linked via Association (master-detail).
For the detail view object i created several view criterias that differentiate in the where clause. (where colour = orange, where colour = blue, where colour = green)
I dragged one view criteria of those 3 on my page as a query, after that i dragged the corresponding view object on the page to create a editable table. In the query i linked the id of the table in the 'resultComponentId'.
So when i start my page i have a drop down menu to select ALL criteria views i created. How is that? i only dragged one of them.
The source looks like this:
<af:query id="qryId1" headerText="Suche" disclosed="true"
value="#{bindings.blueViewCriteria.queryDescriptor}"
model="#{bindings.blueViewCriteria.queryModel}"
queryListener="#{bindings.blueViewCriteria.processQuery}"
queryOperationListener="#{bindings.blueViewCriteria.processQueryOperation}"
resultComponentId="t7" modeChangeVisible="false"
saveQueryMode="readOnly"/>
Answers
-
So when i start my page i have a drop down menu to select ALL criteria views i created. i only dragged one of them.
Is not actually adding all view criteria, only a drop-down list. If no view criteria is dragged, is the drop-down list still not available?
-
I dont really understand your question @dvohra21.
I try to explain again. I have multiple view criterias for my view object (SelectAllCarstThatAreBlueViewCriteria, SelectAllCarsThatAreWhiteViewCriteria, SelectAllCarsThatAreYellowViewCriteria).
If i drag one of those ViewCriterias into my page, lets say the SelectAllCarsThatAreBlueViewCriteria and run my page i can choose from all 3 of them in the drop-down list, not only SelectAllCarsThatAreBlueViewCriteria. Can i configure this somewhere that the enduser only gets access to SelectAllCarsThatAreBlueViewCriteria?
-
Timo Hahn Senior Principal Technical Consultant - Oracle ACE Director Member, Moderator Posts: 38,458 Red Diamond
Do you show the af:query in advanced mode?
In this mode all view criteria available on a VO are shown. If you only need one, show the af:query in basic mode by setting
modeChangeVisible="false"
on the af:query.
If this is not what you are talking about, add some images to this thread showing the problem you have.
Timo
-
I already set modeChangeVisible = false on my af:query.
i only dragged one viewCriteria on my .jsf page but the af:query shows all of them. And in the source there is nothing defined that it should work this way. Is there another configuration somewhere?
-
Timo Hahn Senior Principal Technical Consultant - Oracle ACE Director Member, Moderator Posts: 38,458 Red Diamond
set
displayMode='simple'
and the whole stored search will be gone.
Timo