Kinetic, Events, row-update value syntax examples

[datadaddy (Scott Janisch)]

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:

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

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:

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

[klincecum (Kevin Lincecum)]

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

Also, are you positive there is data in there?

[hmwillett (Hannah Willett)]

@datadaddy

My belief is “Value” parameter is json formatted

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

[datadaddy (Scott Janisch)]

@hmwillett

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

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

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

[datadaddy (Scott Janisch)]

@klincecum

Also, are you positive there is data in there?

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

[klincecum (Kevin Lincecum)]

@datadaddy

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

[hmwillett (Hannah Willett)]

@datadaddy

why does it look like this ?

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.

[datadaddy (Scott Janisch)]

@klincecum

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

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

[hmwillett (Hannah Willett)]

More like:

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

[klincecum (Kevin Lincecum)]

@datadaddy

you guys are the best

@hmwillett

NSFW GIF

We bleed so you guys don’t have to.