28
Views
2
Comments
[Expandable Table Row] Handling of 1 to many relationship in expandable row
expandable-table-row
Reactive icon
Forge asset by Rúben Meireles

Background:  two entities here : JobMaintenance and JobDetail  (1 JobMaintenance have many jobdetails)

1. Job Maintenance:


2. JobDetail: JobMaintenanceID as foreign key


----------------------------------------------------------------------------------------------

My expectation is to expand record in JobDetail (Only show the top phase code of each jobMaintenanceID and expand the rest of the phase in jobDetail ):

- Below is the JobDetail Table, and we can see there are two JobMaintenanceID : 3580 and 3581
-->In this case How can I only show the top record of each maintenanceID in JobDetail table? and show the rest of the phase inside ? 

- If I Use the block , it should be two aggregates for jobdetail? and my function in this page seems will be affected?? 

-----------------------------------------------------------------------------------------------------------------------------------------


Also, I try to use the JobMaintenance table first and create a block for JobDetail.

Seems it cant pass the JobMaintenanceID correctly. 

- Only JobMaintenance table

- Inside the record, I put block with JobDetail table inside (Input parameter is the jobmaintenance ID from above aggreagate), but the result seems not correct

- The result: not consistent, inside the content are same for all record, not show the relavant JobDetail of JobMaintenanceID



-------------------


Would please advice how to realize my expectation in a correct way. Thanks.

2023-06-12 05-32-53
Ananya Ghosal

Hello @Winnie Lam ,

Hope you are doing great!

I think, the below document will help you:

https://www.outsystems.com/forge/component-overview/10423/expandable-table-row-o11

Also, there is a small JavaScript component which might be helpful. You can have a look:

https://www.outsystems.com/forums/discussion/29336/table-rows-expand-collapse-for-web-app/

Best Regards,

Ananya




2023-06-12 05-32-53
Ananya Ghosal

Hi @Winnie Lam ,

Sorry, I forgot to add this link in my previous reply. He was facing exact similar issue as yours and there is a solution. So, you can try this link:

https://www.outsystems.com/forums/discussion/86127/expandable-table-row-multirows-in-the-expandable-container/

Best Regards,
Ananya

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.