Warning: The magic method GW_GoPricing_Elementor::__wakeup() must have public visibility in /home1/stepf0sq/public_html/wp-content/plugins/go_pricing/includes/vendors/elementor/class-elementor.php on line 46

Warning: Cannot modify header information - headers already sent by (output started at /home1/stepf0sq/public_html/wp-content/plugins/go_pricing/includes/vendors/elementor/class-elementor.php:46) in /home1/stepf0sq/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1893

Warning: Cannot modify header information - headers already sent by (output started at /home1/stepf0sq/public_html/wp-content/plugins/go_pricing/includes/vendors/elementor/class-elementor.php:46) in /home1/stepf0sq/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1893

Warning: Cannot modify header information - headers already sent by (output started at /home1/stepf0sq/public_html/wp-content/plugins/go_pricing/includes/vendors/elementor/class-elementor.php:46) in /home1/stepf0sq/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1893

Warning: Cannot modify header information - headers already sent by (output started at /home1/stepf0sq/public_html/wp-content/plugins/go_pricing/includes/vendors/elementor/class-elementor.php:46) in /home1/stepf0sq/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1893

Warning: Cannot modify header information - headers already sent by (output started at /home1/stepf0sq/public_html/wp-content/plugins/go_pricing/includes/vendors/elementor/class-elementor.php:46) in /home1/stepf0sq/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1893

Warning: Cannot modify header information - headers already sent by (output started at /home1/stepf0sq/public_html/wp-content/plugins/go_pricing/includes/vendors/elementor/class-elementor.php:46) in /home1/stepf0sq/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1893

Warning: Cannot modify header information - headers already sent by (output started at /home1/stepf0sq/public_html/wp-content/plugins/go_pricing/includes/vendors/elementor/class-elementor.php:46) in /home1/stepf0sq/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1893

Warning: Cannot modify header information - headers already sent by (output started at /home1/stepf0sq/public_html/wp-content/plugins/go_pricing/includes/vendors/elementor/class-elementor.php:46) in /home1/stepf0sq/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1893
{"id":3461,"date":"2021-06-26T11:56:43","date_gmt":"2021-06-26T11:56:43","guid":{"rendered":"https:\/\/markitiers.in\/step\/?p=3461"},"modified":"2021-07-16T11:32:13","modified_gmt":"2021-07-16T11:32:13","slug":"master-detail-page-creation-in-adf","status":"publish","type":"post","link":"https:\/\/stepforwardsolution.com\/master-detail-page-creation-in-adf\/","title":{"rendered":"Master-Detail Page creation in ADF"},"content":{"rendered":"

A master-detail relationship is an association that reflects a\u00a0primary-foreign key relationship between the database tables. The master is based on the table with the primary key, and the detail data block is based on the table with the foreign key. A master-detail relationship equates to the one-to-many relationship in the entity relationship diagram.<\/p>

1. Click\u00a0New Application<\/strong>, which open\u00a0Create Fusion Web Application\u00a0<\/strong>Wizard. Type\u00a0Application Name\u00a0<\/strong>as \u201cMasterDetail\u201d<\/strong>\u00a0and select \u201cFusion Web Application (ADF)\u201d\u00a0<\/strong>option. Click finish creates\u00a0Model<\/strong>\u00a0and\u00a0Viewcontroller\u00a0<\/strong>architecture.<\/strong><\/p>

\"1\"<\/figure>

2. Connect to the database connection\u00a0HR\u00a0<\/strong>as shown.<\/p>

\"2\"<\/figure>

3. Click on\u00a0\u201cQuery\u201d<\/strong>\u00a0shows all the tables in HR database connection. Select\u00a0Departments\u00a0<\/strong>and\u00a0Employees\u00a0<\/strong>table and move them to the left side to Create\u00a0EO.<\/strong><\/p>

\"3\"<\/figure>

4. Move list of already selected EO to the left side to create\u00a0Updatable VO<\/strong><\/p>

\"4\"<\/figure>

5. Select the\u00a0Application Module (AM)\u00a0<\/strong>checkbox as shown. Click\u00a0finish<\/strong>\u00a0and\u00a0Save all<\/strong>.<\/p>

6. All the\u00a0View links and Associations\u00a0<\/strong>between tables created automatically as shown in Application Navigator and\u00a0Run\u00a0<\/strong>the\u00a0AM<\/strong>\u00a0to test the\u00a0Data Model\u00a0<\/strong>before it will create in web page.<\/p>

\"5\"<\/figure>

7. Click on\u00a0ViewControlle<\/strong>r \u00e0\u00a0New<\/strong>\u00e0\u00a0New Gallery\u00a0<\/strong>\u00e0JSF<\/strong>\u00e0\u00a0JSF Page<\/strong>. Click Ok<\/p>

\"6\"<\/figure>

8.\u00a0Type File Name \u201cMaster-Detail.jspx\u201d\u00a0<\/strong>and select\u00a0Blank Page<\/strong>. Click Ok.<\/p>

\"7\"<\/figure>

9.\u00a0Drag and Drop the \u201cEmployees3\u201d\u00a0<\/strong>from the data control to editor and select<\/p>

Master-Detail\u00a0<\/strong>with \u201cADF Master Form and Detail Table<\/strong>\u201d as shown.<\/p>

\"8\"<\/figure>
\"9\"<\/figure>

Master-Detail in web browser.<\/p>

\"10\"<\/figure>","protected":false},"excerpt":{"rendered":"

A master-detail relationship is an association that reflects a\u00a0primary-foreign key relationship between the database tables. The master is based on the table with the primary key, and the detail data block is based on the table with the foreign key. A master-detail relationship equates to the one-to-many relationship in the entity relationship diagram. 1. Click\u00a0New…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_jetpack_memberships_contains_paid_content":false},"categories":[41],"tags":[],"class_list":["post-3461","post","type-post","status-publish","format-standard","hentry","category-oracle-adf","category-41","description-off"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/stepforwardsolution.com\/wp-json\/wp\/v2\/posts\/3461","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/stepforwardsolution.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/stepforwardsolution.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/stepforwardsolution.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/stepforwardsolution.com\/wp-json\/wp\/v2\/comments?post=3461"}],"version-history":[{"count":3,"href":"https:\/\/stepforwardsolution.com\/wp-json\/wp\/v2\/posts\/3461\/revisions"}],"predecessor-version":[{"id":3812,"href":"https:\/\/stepforwardsolution.com\/wp-json\/wp\/v2\/posts\/3461\/revisions\/3812"}],"wp:attachment":[{"href":"https:\/\/stepforwardsolution.com\/wp-json\/wp\/v2\/media?parent=3461"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/stepforwardsolution.com\/wp-json\/wp\/v2\/categories?post=3461"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/stepforwardsolution.com\/wp-json\/wp\/v2\/tags?post=3461"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}