Discussions
Categories
- 196.7K All Categories
- 2.2K Data
- 235 Big Data Appliance
- 1.9K Data Science
- 449.8K Databases
- 221.6K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 477 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.9K SQL & PL/SQL
- 21.3K SQL Developer
- 295.4K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.1K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 153 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 158 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
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 396 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 170 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 230 Portuguese
ADF Mobile - Joined Table Views

How to pass PK of table as FK to new AMX view.
Not sure how to go about this.
Should I specify a View Criteria of the Child view with Bind Variable of Parent Table PK. If so, how. (ex. WHERE parent.pk = child.fk)
Do not want to have a Parameter Form, just taking the PK of parent used as FK of child view, as a Mobile Button.
Best Answer
-
User,
Always mention your JDev version. Check out this blog : Andrejus Baranovskis Blog: Master-Detail ADF BC Web Service for ADF Mobile
-Arun
Answers
-
i am not sure, i understand you fully.
But either you use view criteria or cant u use master detail
-
on the first amx view is a form with a pk value
would like a button to take that pk and pass it to a new amx view which then displays a new form, the pk is now the fk in the child table . one to many relationship
customer has a subscription , subscription has many customers
want to show specific subscription for customer
-
Okay I figured it out.
I made a View Criteria for the child VO, where the PK value was accepted.
Also added a WHERE clause into my query - WHERE parent.pk = child.fk
On the AMX page, made a button that just re-directs to the next AMX view.
On the child view, I just passed in the pageFlowScope parameter which was taking the Parent PK , where findCriteria + findControl were 'Optional' it only took the Parent PK, and returned the appropriate child record.
Confusing but very simple..
-
New Issue:
parent =================> child(parent) ==========> child
pageFlowScope pageFlowScope ? Where is the binding value coming from ?
from list from parent
-
User,
Always mention your JDev version. Check out this blog : Andrejus Baranovskis Blog: Master-Detail ADF BC Web Service for ADF Mobile
-Arun
-
Ok, I was assigning as pageflowscope variable to the result.
After removing that and setting the Master key(s) to be invoked, within executable bindings, when the 3rd child was executed, records were loaded accordingly.
Thank you