Dataview-Condition widget not working for GUID comparison

[mgerbi (Mike Gerbi)]

I’ve spent about 2 hours on this one widget and I need some assistance, maybe I’m not seeing something.

I have a dataview-condition with the following expression

I have saved the guid of the row I need to update in a previous step and the value is there in the sysGlobalVariable dataview. Funny thing is, this was working yesterday, but because I deleted and re-added widgets/arrows on my event, the subsequent widgets didn’t fire anymore and I had to recreate most of the event. Now this one condition isn’t working.

Here is the data of the result - no rows.

Here is the debug from two different ways of doing it. The first way seems to be the right syntax because I get no errors.

'{UD02.SysRowID}' = '#_trans.dataView('sysGlobalVariable').dataRow(0)['GuidToInit']_#'

I used this expression for this result.
‘{UD02.SysRowID}’ === ‘{sysGlobalVariable.GuidToInit}’

I’ve tried various different ways with the syntax. It doesn’t like double quotes but needs to be encased in single because of the format of the guid itself.

The data is there is the UD table

So, any suggestions on how to find the row by the GUID? Is row-find better?

[GabeFranco (Gabriel Franco)]

Yes, I would do this as a row-find, row-current-set, row-update.

[mgerbi (Mike Gerbi)]

That doesn’t seem to work either. I had to use single quotes because the double errored out.

I selected the third row in the grid so I should have gotten a value higher than -1.

[GabeFranco (Gabriel Franco)]

Maybe it’s being weird because of datatypes? You could try without the quotes so it doesn’t try to match as a string.

Since it’s a UD02 row, you should have a unique match between the keyfields Company, Key1, Key2, Key3, Key4, Key5, could you match the row that way?

[mgerbi (Mike Gerbi)]

Yep! Good call!