Skip to Main Content
Feature Request FR-3388
Product Area Page Components
Status CLOSED

4 Voters

Enable master detail CARD component

alex rabinovich Public · Sep 22 2023

Idea Summary
Enable developers to create cards that will represent master/child data

Use Case
We are migrating homegrown dotnet app which shows to user list of cards and inside every card - listview of child records of the specific parent that appears in the card body.

Example - present customer orders, one card per order with mininal order information and inside the order card - show current order lines (item+qty+shipping status). Preferably -  allow it to be editable.

Preferred Solution (Optional)
Allow SQL statement with CURSOR or XMLAgg that returns child records for current parent line.
We would like to have APEX parse the SQL, identify parent and child columns from CURSOR/XMLAgg and allow it to be mapped.
Another option - allow us to use template directives that can loop over CURSOR field and not just split of a string.

We reviewed this idea carefully, and while it was interesting, we concluded that it is unlikely to make its way into APEX in the foreseeable future.

Comments

Comments

  • mypro_mao OP 1.8 years ago

    Greate idea. 

    Or can add subregion inside cards region like  dynamic content type.

  • sorin apalaghie OP 1.8 years ago

    well… This is something you can already achieve with existing functionality. You simply need to listagg your detail info within the SQL Query and then use template directives to loop through your list aggregated data to render an html list or table containing the order details.

  • hachemi.z OP 1.8 years ago

    Variations will be very expensive to implement , in other hand you can customize your component very easily. 

    an excellent blog by Jon Dixon is here .

  • alex rabinovich OP 1.8 years ago

    @hachemi.z Thanks for the reply. Indeed the example is nice. In the example - we have a table with single row - same level as data in the title. How we can select for certain title multiple records and fields, for example in Oracle loved DEPT/EMP example - for every DEPT (dname) in title, show table from EMP (eno, ename) ?

    I could not find a way to split the LISTAGG concatenated string we loop through into separate fields.

  • sorin apalaghie OP 1.8 years ago

    @alex rabinovich You can have nested loops if that is the question.

  • alex rabinovich OP 1.8 years ago

    @sorin apalaghie Thanks. You mean loop inside loop and split rows by “|” and columns by “~” for example?

  • sorin apalaghie OP 1.8 years ago

    @alex rabinovich  Yes. That's the approach I used in the past.

  • sorin apalaghie OP 1.8 years ago

    For more hardcore scenarios (Example: I needed some forms generated with APEX_ITEM within a collapsible section of each card, I created a hidden div for each card and gave them a unique ID, then I generated the forms using APEX_ITEM within a hidden PL/SQL Dynamic Content region, and last I appended the html content to the divs on the card.