I am really struggling to bind this repeat to a table.
I have a server connect and a data view on my page.
And for the life of me I cannot get the data into the table row’s
Any help would be appreciated
Maybe you can explain which data exactly are you trying to use for the repeat and what does not work?
The data in the image is what is being returned by server connect.
I want a row per repeat invoice line
repeat[0].Invoice
repeat[1].Invoice
repeat[2].Invoice
<dmx-data-view id="data_viewInvoices" dmx-bind:data="scInvoices.data.repeat"></dmx-data-view>
Can you paste (at least part of) your data here so i can check what’s exactly returned?
{
"repeat": [
{
"Invoice": {
"Date": "/Date(1667174400000+0000)/",
"Type": "ACCPAY",
"Total": 108.6,
"Status": "AUTHORISED",
"Contact": {
"Name": "PowerDirect",
"Phones": [
],
"Addresses": [
],
"ContactID": "dec56ceb-65e9-43b3-ac98-7fe09eb37e31",
"ContactGroups": [
],
"ContactPersons": [
],
"HasValidationErrors": false
},
"DueDate": "/Date(1668038400000+0000)/",
"Payments": [
],
"SubTotal": 103.43,
"TotalTax": 5.17,
"AmountDue": 108.6,
"HasErrors": false,
"InvoiceID": "2175c381-d323-4e20-8c94-7680ea7f85d3",
"LineItems": [
{
"TaxType": "RRINPUT",
"Quantity": 1,
"Tracking": [
],
"TaxAmount": 5.17,
"LineAmount": 108.6,
"LineItemID": "b768f5fd-0ada-4cba-a3cd-7d1f22ad5aaa",
"UnitAmount": 108.6,
"AccountCode": "445",
"Description": "Monthly electricity"
}
],
"Reference": "",
"AmountPaid": 0,
"DateString": "2022-10-31T00:00:00",
"CreditNotes": [
],
"Prepayments": [
],
"CurrencyCode": "GBP",
"CurrencyRate": 1,
"IsDiscounted": false,
"Overpayments": [
],
"DueDateString": "2022-11-10T00:00:00",
"InvoiceNumber": "RPT445-1",
"AmountCredited": 0,
"HasAttachments": false,
"UpdatedDateUTC": "/Date(1301876345573+0000)/",
"LineAmountTypes": "Inclusive",
"InvoiceAddresses": [
],
"RepeatingInvoiceID": "619e3696-7b65-4c6e-a790-305de97ca9d9",
"InvoicePaymentServices": [
]
}
},
{
"Invoice": {
"Date": "/Date(1640736000000+0000)/",
"Type": "ACCREC",
"Total": 500,
"Status": "PAID",
"Contact": {
"Name": "Ridgeway University",
"Phones": [
],
"Addresses": [
],
"ContactID": "a871a956-05b5-4e2a-9419-7aeb478ca647",
"ContactGroups": [
],
"ContactPersons": [
],
"HasValidationErrors": false
},
"DueDate": "/Date(1641600000000+0000)/",
"Payments": [
{
"Date": "/Date(1641600000000+0000)/",
"Amount": 500,
"PaymentID": "eea216c6-29c6-4de2-83f4-4196ae3bfaac",
"Reference": "INV-0003",
"HasAccount": false,
"CurrencyRate": 1,
"HasValidationErrors": false
}
],
"SubTotal": 416.67,
"TotalTax": 83.33,
"AmountDue": 0,
"HasErrors": false,
"InvoiceID": "7ea31cd8-045c-4871-8cda-c0420953a39c",
"LineItems": [
{
"TaxType": "OUTPUT2",
"Quantity": 1,
"Tracking": [
],
"TaxAmount": 83.33,
"LineAmount": 500,
"LineItemID": "d2621e25-787b-4868-bdbb-cb2933788b4b",
"UnitAmount": 500,
"AccountCode": "200",
"Description": "Retainer for consulting work"
}
],
"Reference": "RPT200-1",
"AmountPaid": 500,
"DateString": "2021-12-29T00:00:00",
"CreditNotes": [
],
"Prepayments": [
],
"CurrencyCode": "GBP",
"IsDiscounted": false,
"Overpayments": [
],
"DueDateString": "2022-01-08T00:00:00",
"InvoiceNumber": "INV-0003",
"SentToContact": true,
"AmountCredited": 0,
"HasAttachments": false,
"UpdatedDateUTC": "/Date(1301880520783+0000)/",
"BrandingThemeID": "5d4dd402-c851-497e-aae1-9ff265c0d15a",
"FullyPaidOnDate": "/Date(1641600000000+0000)/",
"LineAmountTypes": "Inclusive",
"InvoiceAddresses": [
],
"RepeatingInvoiceID": "abef034a-9498-4af3-9831-365f08f7b13a",
"InvoicePaymentServices": [
]
}
},
{
"Invoice": {
"Date": "/Date(1643328000000+0000)/",
"Type": "ACCREC",
"Total": 1000,
"Status": "PAID",
"Contact": {
"Name": "Ridgeway University",
"Phones": [
],
"Addresses": [
],
"ContactID": "a871a956-05b5-4e2a-9419-7aeb478ca647",
"ContactGroups": [
],
"ContactPersons": [
],
"HasValidationErrors": false
},
"DueDate": "/Date(1644192000000+0000)/",
"Payments": [
{
"Date": "/Date(1644192000000+0000)/",
"Amount": 1000,
"PaymentID": "6190117a-7849-423c-a155-398aed253fa3",
"Reference": "INV-0004",
"HasAccount": false,
"CurrencyRate": 1,
"HasValidationErrors": false
}
],
"SubTotal": 833.34,
"TotalTax": 166.66,
"AmountDue": 0,
"HasErrors": false,
"InvoiceID": "4f9d9bcc-3c75-4884-93a4-19d3b5a4b5f8",
"LineItems": [
{
"TaxType": "OUTPUT2",
"Quantity": 1,
"Tracking": [
],
"TaxAmount": 83.33,
"LineAmount": 500,
"LineItemID": "1c42ea22-2412-4bc4-9a86-60f1b770ab51",
"UnitAmount": 500,
"AccountCode": "200",
"Description": "Retainer for consulting work"
},
{
"Item": {
"Code": "Train-MS",
"Name": "Half day training - Microsoft Office",
"ItemID": "489558f5-27b7-4f37-ad9f-d84611c2e2ab"
},
"TaxType": "OUTPUT2",
"ItemCode": "Train-MS",
"Quantity": 1,
"Tracking": [
],
"TaxAmount": 83.33,
"LineAmount": 500,
"LineItemID": "737e70da-466b-4450-a58d-938cb1e5c8b4",
"UnitAmount": 500,
"AccountCode": "200",
"Description": "Half day training - Microsoft Office"
}
],
"Reference": "RPT200-1",
"AmountPaid": 1000,
"DateString": "2022-01-28T00:00:00",
"CreditNotes": [
],
"Prepayments": [
],
"CurrencyCode": "GBP",
"CurrencyRate": 1,
"IsDiscounted": false,
"Overpayments": [
],
"DueDateString": "2022-02-07T00:00:00",
"InvoiceNumber": "INV-0004",
"SentToContact": true,
"AmountCredited": 0,
"HasAttachments": false,
"UpdatedDateUTC": "/Date(1301880539753+0000)/",
"BrandingThemeID": "5d4dd402-c851-497e-aae1-9ff265c0d15a",
"FullyPaidOnDate": "/Date(1644192000000+0000)/",
"LineAmountTypes": "Inclusive",
"InvoiceAddresses": [
],
"RepeatingInvoiceID": "abef034a-9498-4af3-9831-365f08f7b13a",
"InvoicePaymentServices": [
]
}
}
]
}
If that’s your data view then what’s the issue?
You select dmx-bind:repeat="data_viewInvoices.data"
as an expression for the repeat children and bind your expressions inside it like {{Invoice.Total}}
Oh I don’t know @Teodor, its been driving me nuts. I restarted Docker, performed an update and redeploy and now its working as expected, thanks for your quick assistance!