Kinetic, Events, row-update value syntax examples

Kinetic ERP
1

Seems like this should be simply, but alas, nothing in app studio eventing seems to be…

I have this (test) event, which is fired by an event-next when a OrderDtl.PartNum changes:

image
image700×216 8.65 KB

I’m trying to move some UD fields from Part into OrderDtl at that time, for row-update I have:

image

I have a dialog shown to stop just before the row-update so I can check the Part Dataview contents first.
Everything is correct, the data is there for my new part number.

but when I trace, the debug output shows the following:

image
image724×124 5.62 KB

I’ve tried:
Part.ShortChar01
{Part.ShortChar01}
‘{Part.ShortChar01}’
they all give the same result

My belief is “Value” parameter is json formatted, which doesn’t seem to make a whole lot of sense here

I’ve also tried moving this to a function since I have quite a few fields to move from Part to OrderDtl, but that’s working on the Table not the DataView and I don’t want it automatically saved and then I would still need to refresh in my event after, which doesn’t feel right.

Thoughts from the great brains out here ?

thanks

2

Try "{Part.ShortChar01}" because, reasons.

Also, are you positive there is data in there?

3

Not so. It takes a format like Kevin posted. "{Part.ShortChar01}".

4

Really, that’s “Expression” not “Value” no ?
why does it look like this ?

image
image381×538 3.62 KB

I’d love to understand the diff between Expression and Value useage

1 Like
5

yes, this is my Part dataview column once my blocking dialog shows: (ShortChar01)

image

6

Line Waiting GIF by South Park

1 Like
7

Because they all look like that. Including ones that take JSON. It doesn’t always need to be JSON, though. (I can’t tell you why, where, or when #TribalKnowledge).

The expression field allows you to use JavaScript to do special things whereas the value is just assigning a value with no other logic.

8

OMG, that worked, I recently convinced myself that single-quotes where needed/better and didn’t think to try that, so of course now would love to know when to use single vs double quotes…AAAARGH

and you’re correct @hmwillett, I had tried ‘{Part.ShortChar01}’ in the supposed json editor and got an error on the formatting, but with “{Part.ShortChar01}” it was syntactically correct at least

thanks, you guys are the best

Over It Ugh GIF

1 Like
9

More like:

That GIF may be NSFW for some, so I'm hiding it. :)

angry computer GIF

2 Likes
10

We bleed so you guys don’t have to.

let's do this season 2 GIF by Ash vs Evil Dead