Data Store Repeat is repeating more than it should

Wappler General
1

Ok, this has to be simple…

I have a datastore that has records in it that I am trying to repeat. But for each item in the datastore my repeat is repeating 6 times, instead of just once.

Here is data store info:

Capture
Capture989×374 58.6 KB

Here is the code. I am doing a nested repeat to pull order data from each of the items in the data store array.

<div dmx-repeat:repeatordersarray="shippingArray.data">
        <div dmx-repeat:repeat1="conn_PackingSlip.data">
            <main class="mt-4">
                <div class="container">
                    <div class="row">
                        <div class="col">
                            <h1 class="font-weight-bold text-right">Individual Packing Slip</h1>
                            <h3 class="text-right">Order Number: {{orderid}}</h3>
                        </div>
                    </div>
                    <div class="row mb-2" id="id_addresses">
                        <div class="col">
                            <div class="row">
                                <div class="col-3">
                                    <p class="pt-2 pb-2 pl-2 pr-2 bg-dark text-white font-weight-bold text-uppercase">Bill To:</p>
                                </div>
                                <div class="col">
                                    <p>{{queryBillingAddress.Name}}<br>{{queryBillingAddress.Contact}}<br>{{queryBillingAddress.Address1}}</p>
                                </div>
                            </div>
                        </div>
                        <div class="col">
                            <div class="row">
                                <div class="col-3">
                                    <p class="pt-2 pb-2 pl-2 pr-2 bg-dark text-light font-weight-bold text-uppercase">Ship To:</p>
                                </div>
                                <div class="col"></div>
                            </div>
                        </div>
                    </div>
                    <div class="row mb-2">
                        <div class="col">
                            <div class="table-responsive">
                                <table class="table">
                                    <thead class="thead-dark">
                                        <tr>
                                            <th scope="col">Ship Via</th>
                                            <th scope="col">PO Number</th>
                                            <th scope="col">FOB</th>
                                            <th scope="col">Date</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <tr>
                                            <th scope="row">1</th>
                                            <td>{{queryInvoice.PurchaseOrderNumber}}</td>
                                            <td>Otto</td>
                                            <td>@mdo</td>
                                        </tr>
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                    <div class="row">
                        <div class="col"></div>
                    </div>
                </div>
            </main>
        </div><!-- End of Invoice Data -->
    </div> <!-- End of Array Repeat -->

Should be simple, but I don’t understand why in the repeat it will show 4 times for each item instead of 1?

Any insight?

2

Shouldn’t the first line be shippingarray.records not data?

IGNORE ME - I was looking at your screenshot on my phone and have since checked in Wappler - it should be .data according to the picker

3

It is hard to say from your screenshots but it looks like you are repeating your shippingArray and then repeating the whole packingSlip data for each one - should it just be the packing slip for that order (maybe using a .where() formatter)?

e.g.

conn_PackingSlip.data.where('packingslipOrderId',orderid,'==')
4

at this point I’m just grabbing the id from the order from the data store and then using a server connect to grab order details.

It just should be repeating so many times thats what I can’t figure out.

I would entertain another way to do it. Maybe load the ids into an array and then repeat those or something?

5

I think it’s to do with the relationship with the SC (conn_PackingSlip)

You can put that Server Connect inside the datastore repeat (but before the repeat that looks at it) so that there is one for each order with its own data

1 Like
6

Yep you are partially right there. I removed the second repeat (the internal one) and exterior repeat repeated the correct amount. So let me fiddle with that and see if I can figure that out.

1 Like
7

Ok, I got it solved! I didn’t actually need the second repeat. I just needed to but the server connect inside the repeat and I was able to get the data I needed. Thanks again @bpj you are always a help! Sometimes I just try to over think things when they are actually very simple.