Kinetic - Looping through rows - SelectSerialNumbersEntry

Kinetic ERP
,
21

Go cry me a river lightweight.

Talk to me when you start binge eating at 2:00am and grab a couple shots of tequila,
because you’ve been crying at a null reference you can’t find for 3 days.

1 Like
22

You Don T Say Meme GIFs | Tenor

23

{CSVRows.Col0} is wrong unless you named your dataview CSVRows, but it looks like you named it FuncDS, so it should be:

{
    "Company": "{CallContextClientData.CurrentCompany}",
    "SerialNumber": "{FuncDS.Col0}",
    "Scraped": false,
    "Voided": false,
    "PartNum": "{SNFormat.PartNum}",
    "SNPrefix": "",
    "SNBaseNumber":"{FuncDS.Col0}",
    "SourceRowID": "00000000-0000-0000-0000-000000000000",
    "TransType": "PUR-STK",
    "PassedInspection": false,
    "Deselected": true,
    "RawSerialNum": "{FuncDS.Col0}",
    "KBLbrAction": 0,
    "PreventDeselect": false,
    "PreDeselected": true,
    "NotSavedToDB": true,
    "SysRowID": "00000000-0000-0000-0000-000000000000",
    "RowMod": "A"
}
24

Doesn’t work :wink:

25

Well, I know THAT.
Just pointing out one small point of error. :stuck_out_tongue:

I’ve got a bit of time. I’ll poke it some more and see if I can get it working here.

1 Like
26

Baby steps.

27

image

28

Not Moving Wake Up GIF by Travis

29

Yayy GIFs | Tenor

I’m at the point of insanity.

30

Welcome to Computer Science 101.

31

Can’t say I ever really left.

1 Like
32

You mean welcome to Kinetic… This is Epicor’s version of life… Zero documentation, heart break and it all ends with the bottle and a shotgun.

33

I’m into ropes more, myself. :smiley: :knot: :wink:

34

And then your drummer goes on to be very successful.

35

Not sure if Nirvana joke or not…?

36

:dancer:

37

This is dumb.
Serial numbers are dumb.

38

You have a dataset (a view) with a table CSVRows, which is populated with CSVRow objects, and each object has a property “Col0”.

To add as many rows as you have in your dataset, you need to do:

foreach (CSVRow row in FuncDS.CSVRows)
{
    row-add(row); // Your binding will then be {row.Col0}
}

I’ll leave it up to you to translate the pseudocode into a Kinetic event with widgets.

39

ezgif-4-81e91fdae1

40

try {FuncDS[0].Col0}, see if it adds one row

or possibly {FuncDS.CSVRows[0].Col0}