Special Characters in Row-Update Expression

Kinetic ERP
,
1

I’m encountering an issue with single quotes in row-update expressions.

Typical Setup (Using single quotes):

  • Ep Binding: ReportParam.Name
  • Expression: '{MyDataview.UD03_Name_c}'.
  • This expression fails with values like O’Brien

Work around (Using double quotes):

  • Ep Binding: ReportParam.Name
  • Expression: "{MyDataview.UD03_Name_c}"
  • Doesn’t fail but displays O\'Brien instead of O’Brien

image
image402×513 7.59 KB

Does anyone know how to handle special characters like single quotes in Epicor’s row-update expression?

Thanks

2

Copy what you have in expression and put in value or remove the quotes from expression

1 Like
3

image

Adding double quotes to the expression in the value field resolved the issue.

image
Interestingly, removing the double quotes from the expression caused the event to fail. It appears that string values require double quotes for row-update to function correctly.

2 Likes