Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Best Approach for Master Detail Implementation using JET and Rest (similar to ADF view links)

Baig MohammedApr 11 2019 — edited Apr 11 2019

Dear Experts,

We have started to embrace JET for our new enterprise application development by shifting from ADF and we have a common requirement as below:

1. Search page - With search criteria(combo boxes) and result (eg: header, line, distributions, 3 entities as in a single row, which mean header info will be repeated for all lines/distributions)

2. We have edit button at row level, to open the Edit page. (We also have Create button to open the Create page and both edit and create are same page.)

3. Now in the create/edit page, we have master details at 3 levels( header as form, line as details table and again distributions as another table below lines)

I want to make changes to all lines and distributions and send the complete Json per header to Rest, to handle Insert/update in Rest service.

What would be best component and approach to use here.? I started with oj-table, I can show all lines in oj-table for that header, but how can i add another table(distributions) below, which would show only those distributions for the selected line. ? I dont want to call rest service to fetch all distributions for selected Line row, as user will be slecting lines one by one and make changes to distributions and will click on Save at the end . If i call Rest service for each line(as mentioned in this blog Andrejus Baranovskis Blog: Oracle JET Master-Detail with ADF BC REST ), my previous changes to distributions will be lost.

http://andrejusb.blogspot.com/2016/05/oracle-jet-master-detail-with-adf-bc.html

Please advise me best approach to achieve this typical implementation of Master and Details, which can be achieved using View Links in ADF.

Copying the sample incomplete UI for reference:

pastedImage_2.png

I need to add another table below this Import ticket lines and should change on line selection, eventually I need to pass entire json(header, lines, distributions) to Rest to insert/update.

Another approach is I can have a column in lines table itself, which will open pop dialog, where I select distributions and once I add them , they will be shown as comma separated in that lines columns, which is not clean approach and also I dont know how to implement it.

If you or your team has already implemented these kind of pages, it would be great if you could send me screenshots of applications and the sample code i could refer

Thank you

pastedImage_5.png

Comments
Post Details
Added on Apr 11 2019
3 comments
396 views