Script for Nasted detail

OL Connect Professional Designer
1

Hi there,

I am new to this detail table wizard. Can I please have some help?
I’m trying to create three seperate detail tables from the nasted detail table.
T1 for Client1(3 details) ,T2 for Client2(1 details) and T3 for Client3(1 details)

image
image1994×773 68.5 KB

image
image2020×761 78.7 KB

However when I use dynamic table wizard it goes through all details in three clients and display all 5 lines.

Any ideas?

Many thanks:grinning:

2

Hi CainZ,

Would you be able to share the data and template?

Erik

3

Hi Erik,

Thanks for your help. the template and datamapper have been attached belowTest2.OL-datamapper (4.6 KB) Test2.OL-template (8.9 KB)

4

Is there any script I can use to control the nasted detail table when it applies repeating?

5

@CainZ at this stage we don’t have a feature to repeat actual tables. You could use the following structure to mimic the desired result.

Erik

<table id="table" class="table--light" data-column-resize="" data-detail="" data-hide-when-empty="" style="width :100%" data-expander="2019">
    <tbody>
        <tr data-repeat="Client">
            <td style="width: 30.62%;">Client</td>
            <td style="width: 42.72%;"></td>
            <td style="width: 26.66%;"></td>
        </tr>
        <tr data-repeat="Client">
            <th style="text-align: left;">EffectiveDate </th>
            <th style="text-align: left;">MappedEffectiveDate </th>
            <th style="text-align: left;">ZeroRated </th>
        </tr>
        <tr data-repeat="Client.details">
            <td style="text-align: left;" data-field="EffectiveDate">@EffectiveDate@</td>
            <td style="text-align: left;" data-field="MappedEffectiveDate">@MappedEffectiveDate@</td>
            <td style="text-align: left;" data-field="ZeroRated">@ZeroRated@</td>
        </tr>
        <tr class="separator" data-repeat="Client">
            <td>&nbsp;</td>
            <td></td>
            <td></td>
        </tr>
    </tbody>
</table>

Additional CSS styles:
.table–light th {
background-color: #E6E6E6;
}
.table–light .separator {
border-bottom: 0;
}

Test2.OL-template (9.3 KB)

image
image816×390 7.49 KB

6

I was thinking I can easily using data-repeat to select perticular nasted table

Anyway, this structure also working fine to me, thanks so much for your help :grinning: